Topics

1

Help for ParamQuery Pro / Is it possible to dynamically change the dataModel?

« on: December 28, 2023, 07:41:53 am »

In version 8.x, it was used as follows:

Code: [Select]

-- Initial settings
dataModel: {data: []}

-- When clicking the search button
$("#btnSearch").click(function() {
var postData = $(form + " :input").serializeObject();
var dataModel = {
location: "remote",
dataType: "JSON",
method: "POST",
url: $(form).attr("action"),
postData: postData
};

$("#gridDiv").pqGrid("option", "dataModel", dataModel);
$("#gridDiv").pqGrid("refreshDataAndView");
});

However, in version 9.x an error occurs.

pqgrid.min.js:9  Uncaught TypeError: Cannot read properties of undefined (reading 'bind')
    at A.callXHR (pqgrid.min.js:9:62732)
    at A.remoteRequest (pqgrid.min.js:9:63058)
    at A.refreshDataAndView (pqgrid.min.js:9:66110)
    at HTMLDivElement.<anonymous> (jquery-ui.min.js:6:8934)
    at Function.each (jquery-2.2.4.min.js:2:2861)
    at a.fn.init.each (jquery-2.2.4.min.js:2:845)
    at e.fn.<computed> [as pqGrid] (jquery-ui.min.js:6:8817)
    at HTMLDivElement.<anonymous> (uprt.common.js?ver=2022052101:43:17)
    at HTMLDivElement.dispatch (jquery-2.2.4.min.js:3:7537)
    at r.handle (jquery-2.2.4.min.js:3:5620)



In version 9.x, how do the grid display data only when the search button is clicked without searching the data when entering the page?

2

Help for ParamQuery Pro / How to use v9 in edge ie mode?

« on: July 13, 2023, 03:30:33 pm »

Hi Paramveer,

I am using version 8.6 in Edge ie mode.

I am trying to upgrade to version 9.

The version 9 demo page does not appear normally in Edge ie mode.

Is there any way to use version 9 in ie mode?

3

Bug Report / Page initialization error

« on: June 14, 2022, 02:38:00 pm »

Hi

I have found some miss behaving in page initialization
The jsfiddle link is https://jsfiddle.net/oz6swk1p/

1. go to page 2.
2. click the "page reset" button.
3. to to page 2.

It shows page 2 data, but the page is still page 1.
If you move to page 3, it becomes page 3 and the move button is also activated.

It seems to work fine if I initialize it on a page other than page 2.

Also, please check whether the method of initializing the page is correct.

Thank you.

4

Bug Report / copy/paste multiple lines text

« on: August 29, 2021, 09:14:41 am »

Hi

I have found some miss behaving in Copy/Past issues.
Below is a link https://paramquery.com/pro/demos/copy_paste

1. Change cell contents of Grid A to multiple lines.
2. Copy multiple cells including that cell.
3. Paste it on Grid B.
4. Then I get the result I don't want.

However, if the starting column is not multiple lines, it works normally.

Please refer to the attached image.

Thank you.

5

Help for ParamQuery Pro / Double click event issue

« on: January 13, 2021, 01:05:18 pm »

Hi Paramvir,

I asked about the issue related to Double click event

Link to previous question : https://paramquery.com/forum/index.php?topic=3956.msg14295#msg14295

When the selectionModel type is set to row, the double-click event does not work.

cellDblClick, rowDblClick both don't work.

I applied version 7.6.1, but it seems that it has not been modified yet.

Reference link : https://jsfiddle.net/2v5ftw1z/

Please check this issue.

6

Help for ParamQuery Pro / Keep checkbox column after refreshCM in 7.6.0 version

« on: January 08, 2021, 11:41:31 am »

Hi Paramvir,

I asked about the issue related to check box before.

Link to previous question : https://paramquery.com/forum/index.php?topic=3848.msg13957#msg13957
I have three questions.

------------------------------------------------------------------------------------------

1. There is an issue that is not yet available in version 7.6.0.

Checkboxes with the same name are still disappearing.

Below is the link of the jsfiddle : https://jsfiddle.net/u9pc6y01/1/

------------------------------------------------------------------------------------------

2. The function(_initTypeColumns) you told me before disappeared from version 7.6.0

------------------------------------------------------------------------------------------

3. In previous versions, the problem was being solved using a function (_initTypeColumns).
Is this function only available in the following formats?
 ex : grid = pq.grid("#grid_json", obj) => grid._initTypeColumns() //  grid = $("#grid_json").pqGrid(obj) => grid.pqGrid("_initTypeColumns")
 
 Below is the link of the jsfiddle: https://jsfiddle.net/p8jkaLdr/1/
     
------------------------------------------------------------------------------------------

Please check.

Thank you.

7

Help for ParamQuery Pro / Double click event

« on: December 28, 2020, 10:00:29 am »

Hi team,

When selectionModel type: "row", can the rowDblClick or cellDblClick events be used?


Below is the link of the jsfiddle:

https://jsfiddle.net/w8v7hzem/

Thank you.

8

Help for ParamQuery Pro / How to display the select box text?

« on: December 22, 2020, 02:48:18 pm »

Hi

I want to display the text of the selected option in the edit state when it is in the general grid state.
The options value is an array of associated value label pairs.

Code: [Select]

        var data = [
            { rank: 1, company: 'Exxon Mobil', revenues: 339938.0, profits: 36130.0 },
            { rank: 2, company: 'Wal-Mart Stores', revenues: 315654.0, profits: 11231.0 },
            { rank: 3, company: 'Royal Dutch Shell', revenues: 306731.0, profits: 25311.0 },
            { rank: 4, company: 'BP', revenues: 267600.0, profits: 22341.0 }
        ];

  var CM = [
                { title: "Rank", width: 100, dataIndx: "rank", editor: {type: "select", prepend: {"":""}, options: [{"1":"one"}, {"2": "two"}, {"3": "three"}, {"4": "four"}]} },
                { title: "Company", width: 200, dataType: "string", dataIndx: "company" },
                { title: "Revenues", width: 150, dataType: "float", dataIndx: "revenues", format: '#.0' },
                { title: "Profits", width: 150, dataType: "float", dataIndx: "profits", format: '#.0' }
            ];


Below is the link of the jsfiddle:

https://jsfiddle.net/54vucynL/

Thank you.

9

Help for ParamQuery Pro / Check for null cell change in batch editing

« on: November 17, 2020, 01:12:21 pm »

If you double-click an empty cell without a value (editing begin) and then enter or move to another cell (editing end), it is recognized as changed even though there is no changed value.

https://paramquery.com/pro/demos/editing_batch


1. Add one blank cell in the batch editing demo above

Code: [Select]

                {
                    title: "Unit Price", width: 100, dataType: "float", dataIndx: "UnitPrice",
                    validations: [{ type: 'gt', value: 0.5, msg: "should be > 0.5" }],
                    render: function (ui) {
                        var cellData = ui.cellData;
                        if (cellData != null) {
                            return "$" + parseFloat(ui.cellData).toFixed(2);
                        }
                        else {
                            return "";
                        }
                    }
                },
                {
                    title: "TEST", width: 100
                },

2. Test cell double click

3. Click Enter or Tap or click elsewhere

4. There is no change in the value of the test cell, but it is displayed as changed.

How do I mark it as unchanged?

Thank you.

10

Bug Report / Multiple row selection error

« on: November 16, 2020, 11:14:27 am »

Hi Team.

In the Selections demo below, an error occurs when multiselecting a number cell.

https://paramquery.com/pro/demos/selection_cell

1. Click number 1 in the number cell row.
2. Hold down the ctrl key in the number cell row and click the number 2.
3. Hold down the shift key in the number cell row and click 6 with the mouse.

This will select rows 1 through 6.


However, if you select the row as shown below, an error occurs.

1. Click number 1 in the number cell row.
2. Hold down the shift key in the number cell row and click 6 with the mouse.



If the selection model is a row, it works fine, but if the selection model is a cell, an error occurs.

I want to make it work even if I set the selection model to row.


Thank you.

11

Help for ParamQuery Pro / Keep checkbox column after refreshCM

« on: September 27, 2020, 06:08:02 am »

Hi Paramvir,

I used refreshCM to variably change the column, but the checkbox appears blank.
I want to know how to keep the checkbox column after refreshCM.


Below is the link of the jsfiddle:

https://jsfiddle.net/mswk2zex/

Thank you.

12

Help for ParamQuery Pro / Grand summary position

« on: June 23, 2020, 07:32:09 am »

Hi,

How can I change the position of the Grand summary row to the top?

13

Help for ParamQuery Pro / Setting line breaks when exporting Excel

« on: June 04, 2020, 07:57:52 am »

Hi Paramvir,

When exporting Excel, setting style: {"white-space": "normal"} causes line breaks (wrap:true).

Is it possible to give a line break effect only for the headline using styleHead?

14

Help for ParamQuery Pro / How to change the value of another column?

« on: June 03, 2020, 03:25:02 pm »

Hi Paramvir,

I want to use a formula to change the values ​​in colB column based on the values ​​in colA column in three ways: normal editing, Excel import and copy &paste.

As you can see in the code below, setting two or more column values in one formula seems to work. Do you still have problems if you keep using it like this?

Code: [Select]

var formulas = [
    ["tax", function( rd ){
        rd.profit = rd.revenues - rd.income;   //Is there any problem using this?
        return rd.amt* 0.25;
    }]
];

Is it possible to enable/disable a formula conditionally as below code?
For example, I want it to be active only when editing, not when importing data.

Code: [Select]

var formulas = [
    ["tax", function( rd ){
        if(condition) {
            rd.profit = rd.revenues - rd.income;
            return rd.amt* 0.25;
        } else {
            return rd.tax;
        }
    }]
];

Thank you.

15

Help for ParamQuery Pro / Import excel with nesting of colModel

« on: June 03, 2020, 02:49:36 pm »

Hi Paramvir,

When there is only one colModel, Excel import is good.
However, in case of nested colModel, data is not set in the column.

Below is the link of the jsfiddle:
https://jsfiddle.net/4q37pf90/

Thank you.