Topics

1

Help for ParamQuery Pro / Issue for Multiple row selection for v4.x to v5.1

« on: April 04, 2019, 04:09:09 pm »

Hi,

I just noticed that for version v4.x to v5.1 when using
selectionModel: {type: 'row', mode: 'block'}
The default behavior is that it will keep adding any rows clicked as selected without using the ctrl or shift key to select multiple row which i think is wrong.
Version before v4.x or above v5.1 is working correctly.

Is there any way to resolve the issue while still using v5.1?

2

Help for ParamQuery Pro / Column format for allowing negative value

« on: March 01, 2018, 06:18:28 pm »

Sorry, please delete this post. Found out the problem is not related to paramquery.

Hi,

May I know how can I specify the column format to allow entering both positive or negative value ?

var colM = [
    { dataIndx: 'amount', dataType: "float", format: "###,###.00" }
];

Regards,
Francis

3

Bug Report / selectionModel problem for 4.0.1

« on: October 18, 2017, 06:22:27 pm »

Hi,

With version 3.4.1 having selectionModel: { type: 'cell', mode: 'block'}, when clicking on each individual row without pressing the ctrl or shift key, only that particular row will be selected which is correct. If need to select more rows then use the ctrl or shift click together with the clicking.

But with 4.0.1, even without pressing the ctrl or shift key together with the clicking on multiple row, more than 1 rows are selected.
This should not be the case.

Hope this issue can be rectified fast.

4

Bug Report / showTitle interferring with paging

« on: August 16, 2017, 08:02:22 pm »

Hi,

When the title is displayed and I set pageModel: {type: ""} to disable paging, there is no problem.
But when I set options for showTitle: false , no grid is displayed.

Please look into it.

Regards,
Francis

5

Help for ParamQuery Pro / How to display only the value of the summary

« on: August 07, 2017, 06:29:34 pm »

Hi,

Currently when I set the column summary as follows

summary: {type: "sum"},
or
summary: {type: "sum", title:"{0}"},

It will always show Sum: xxx.xx

How can I remove the 'Sum:' from the summary cell and directly display the value instead.

6

ParamQuery Pro Evaluation Support / editCell Method problem

« on: April 27, 2017, 10:16:43 pm »

Hi,

I've a datagrid with multiple columns like barcode, productid, description, pkg, remarks, qty and price.
description and packaging column is non editable.
After entering data in barcode or productid, I want to to update the value of description, pkg, remarks & price according to values found from an array of objects which match the specific barcode or product id.
I've no problem in updating the values of the fields and then refreshing the row using the below code from the cellSave event.

        ui.rowData['description'] = row.description;
        ui.rowData['remarks'] = row.remarks;
        ui.rowData['pkg'] = row.pkg;
        ui.rowData['price'] = row.price;
        ui.rowData['qty'] = 1;
        grid.pqGrid("refreshRow", {rowIndx: ui.rowIndx});
        grid.pqGrid("editCell", {rowIndx: ui.rowIndx, dataIndx: "qty"});

With the last line above, I wanted it to jump directly to the qty column and open the editor after that.
However it always jump to the column after qty.
I think it is due to the onSave options for editModel having values of "nextFocus" or "nextEdit".
How can I cancel the keyboard event to move to the next column and go to the qty column instead after updating only in the barcode or productid column.

 Please advise.

Regards,
Francis

7

ParamQuery Pro Evaluation Support / Support for multicolumn autocomplete input

« on: April 18, 2017, 09:04:24 pm »

Hi,

I've spend a full day trying to implement a multicolumn autocolumn editor inside the grid which extends the autocomplete widget and get it to work properly.
The extension widget can be found in
http://www.jqueryscript.net/download/Multicolumn-Autocomplete-Control-with-jQuery-jQuery-UI.zip

If after typing or selecting the item from the autocomplete dropdown list, and press enter or tab key to move to next cell, there is no problem. But if we click on any other cell or outside the grid, the editor will still remain and give an error.
"cannot call methods on autocomplete prior to initialization; attempted to call method 'widget'"

I've found that it is due to following line inside the pqgrid.min.js
else if(h.hasClass("ui-autocomplete-input")){if(h.autocomplete("widget").is(":visible"))return}

To bypass this issue, I've resorted to remove the original class "ui-autocomplete-input" and add the class "ui-mcautocomplete-input" instead so that it will not be affected by the above line of code.

Just wanted to inquire if there is any problem by doing so ? What will happen if the autocomplete is still visible and lost focus ?

8

ParamQuery Pro Evaluation Support / Duplicate entry in addList & updateList when adding new row.

« on: April 06, 2017, 08:06:43 pm »

Hi,

When ever I tried to add new rows to grid with a string column as its primary key column, there will be duplicate entry in both addList and updateList. For grid with auto incremental primary key column, I do not have this problem.

Attached test.txt is the code that I've used.
I've also attached 2 image.

Image 1 is after I press the add new row button and then type in the primary key. After that I press get Changes to confirm that it only exists in addRow.

Next I enter some text in the second column and then press the get Changes button again. And this time it shows that it appears in both addList and updateList. There is no red icon on the primary key column but there is red icon on the 2nd column.

Please advise on what is wrong.