Messages

1

Help for ParamQuery Pro / Re: Inline Editing: Prevent regex validation when cell is empty

« on: March 21, 2019, 11:33:41 am »

Ah... I didn't notice that a callback function can be used for validation type.

Many thanks! 

2

Help for ParamQuery Pro / Inline Editing: Prevent regex validation when cell is empty

« on: March 20, 2019, 02:10:00 pm »

Hello,

I'm using a regex validation for a date field when editing a cell with date value. Is it possible to prevent the validation when the value of the cell is empty?

Thanks,
Syreta

3

Help for ParamQuery Pro / Shorten Text from left side

« on: February 14, 2019, 03:43:19 pm »

Hello,

I disabled text wrapping for cells so the grid shortens the text inside the cell. That's good! But is it possible to shorten the text from the left side instead of right?
Or do I have to write my own function for this?

Thanks,
Syreta

4

Help for ParamQuery Pro / Show/Hide Rows

« on: December 05, 2018, 01:54:37 pm »

Hello,

I'm using the "pq_hidden" attribute for hiding or showing rows (depending on other data attributes), when the user clicks on specific mode options. This works fine! But there are two "issues":

- After hiding some rows, the "total records" value in the grid footer will not be updated by the new value.

- After hiding some rows, rows that are still showing, will stay on a second page, even though max entries count of rows per page is greater than the (new) total value of rows. For example: When I have 137 total rows and max. 100 rows per pages, I get two pages in the grid. After hiding 57 rows, there are still two pages in the grid, even though there should be only one page! And possibly some rows stays on the second page if they are shown on the second page before hiding some rows.

Are there ways to get these points fixed?

Thanks,
Syreta

5

Help for ParamQuery Pro / Export Hidden Fields

« on: October 11, 2018, 07:16:22 pm »

Hello,

some time ago, you told me to use the "copy" attribute for controlling if a column will be exported or not. But it seems, that this attribute is ineffective when attribute "hidden" is true.
Is there a way to export hidden columns to xlsx?

Thanks in advance,
Syreta

6

Help for ParamQuery Pro / Re: Multiselect in Grid Editor

« on: October 11, 2018, 03:38:45 pm »

Oh... thought too complicated - I could have come to that myself.    Many Thanks!!!

7

Help for ParamQuery Pro / Re: Multiselect in Grid Editor

« on: October 11, 2018, 12:23:59 pm »

This works fine - thank you!
A small last request regarding to the multiselect feature: I want to be able to write something different (maybe a custom text) into the own cell!

As I said...

Code: [Select]

ui.rowData["SCS_PLANTS_IDS"] = ui.$cell.find("select").val();
... works fine, but it seems like it's not possible to write into the own cell:

Code: [Select]

ui.rowData["SCS_PLANTS_TEXT"] = "Hello World";
... does not work 

How can I solve this?

8

Help for ParamQuery Pro / Re: Multiselect in Grid Editor

« on: October 10, 2018, 01:21:30 pm »

This works for me, thanks!

I want to control the (pre)selection of the multiselect by the values of another cell. I was already able to use these values for the preselection of the options by doing this ("SCS_PLANTS_IDS" is another column!):

Code: [Select]

function (ui) {
if(ui.rowData["SCS_PLANTS_IDS"] != null && ui.rowData["SCS_PLANTS_IDS"] != ""){
var scsPlantIDs = ui.rowData["SCS_PLANTS_IDS"].toString().split(",");
} else {
var scsPlantIDs = [];
}

ui.$editor.val(scsPlantIDs).pqSelect({
multiplePlaceholder: "Select SCS Plants",
edgeDetect: false,
checkbox: true,
radio: true
});
}

But how can I write the values of the selected options back to the foreign cell? When I have a single select I was able to do this with the mapIndices attribute, but it does not work with the multiple select. Is it possible to use the getData Event for this?

9

Help for ParamQuery Pro / Multiselect in Grid Editor

« on: October 09, 2018, 05:50:58 pm »

Hi,

is it possible to use pqselect multiple mode in the grid editor?

Code: [Select]

editor: { type: 'select' }... initializes a normal (single) select only.

Thanks,
Syreta

10

Help for ParamQuery Pro / Re: editFirstCellInRow does not work correctly

« on: October 09, 2018, 11:18:56 am »

This works for me - great thanks! 

11

Help for ParamQuery Pro / Re: editFirstCellInRow does not work correctly

« on: October 08, 2018, 04:09:34 pm »

Update:

I think there is no bug in the functions, but in the grid!
When I add a new row to the grid and scroll down manually, the behavior is the same! It scrolls down, I can see my new added row for a short moment and then it automatically scrolls up to the penultimate row and I have to scroll down a second time (but only for the one row I added)... 

12

Help for ParamQuery Pro / editFirstCellInRow does not work correctly

« on: October 08, 2018, 02:34:49 pm »

Hi,

when I add a new row to my grid, I want to to be able to edit the first cell automatically without a click.

I found the function editFirstCellInRow() for this. But when I call this function, the input field of the first cell is displayed only for a very short moment, then it disappears immediately!
Incidentally, the same happens when I call the function goToPage(). The grid scrolls down to my new added row and after a very short moment it scrolls up to the penultimate (already existing) row.

Do I have to change any initializing options of my grid to get this functions working correctly?

I'm using v5.1...

Thank you in advance for your help!

Best Regards,
Syreta

13

Help for ParamQuery Pro / Re: Checkbox Columns in Excel Export

« on: June 26, 2018, 06:57:11 pm »

Thank you very much! 

14

Help for ParamQuery Pro / Checkbox Columns in Excel Export

« on: June 26, 2018, 12:25:29 pm »

Hello,

Is there a way to prevent checkbox-columns in the Excel Export?
Currently there is the HTML-Tag for the checkbox in the Excel file... it would be perfect to remove the whole column automatically.

Thanks,
Syreta

15

Help for ParamQuery Pro / Re: Check/Uncheck Checkbox in cellRightClick Event

« on: June 26, 2018, 12:13:26 pm »

Thanks for your answer, this works for me!
When I update the checkbox of the current row with this code, I want to uncheck all other checkboxes. For this, I found the following code:

Code: [Select]

$("#grid_table").pqGrid("setSelection", null);
Is it the correct way to do this before updating the current row or is there a better way?