Messages

1

Help for ParamQuery Grid (free version) / Re: How to Filter on Nested Json

« on: May 17, 2022, 01:31:40 am »

Hi, have you able to fix this issue? I am also getting the same issue, cellData return "[Object Object]" and I am not able to read that.

2

Help for ParamQuery Grid (free version) / Filter is not working for rowData having reference value

« on: May 11, 2022, 08:09:48 pm »

Hi,

My filter is not working for the columns having reference value as show below. Can you guide me how this will get fix?

title: GS.res.freightRate.TransportTypeLabel, dataType: "string", editable: false, align: "left", minWidth: 120, dataIndx: "TransportationType",
                render: function (ui) {
                    return ui.rowData['TransportationType']['SearchValue'];                   
                }, filter: { crules: [{ condition: 'contain' }], listeners: ['keyup'] },

3

Help for ParamQuery Grid (free version) / dataIndx not able to read $ref

« on: April 20, 2022, 04:03:43 am »

I am trying to read the value from the object to show that on grid but it is not working. For example I need to show "Product Name" from the object called "Product" like this dataIndex: "Product.Name". What is happing it returns multiple records but showing the "Name" only for the first records and for other it is just setting the reference point to first record.
First record example:- Product { Name : XYZ}
Other records example:- Product { $ref: 1}

I am not able to use this reference. Can you guide me how i can use this $ref to show the Name on the grid.

Thank you.

4

Help for ParamQuery Grid (free version) / Cascade Checkbox on Row Grouping not working for collapsed rows

« on: November 25, 2021, 03:24:09 am »

Hi,

I am using cascade checkbox for my grid. when i checked checkbox on grouped row, it didnt checked all the checkboxes on the detail rows.
Can you check and let me know if  i am doing something wrong. For your reference i am sharing screenshot.


 groupModel: {
                checkbox: true,
                checkboxHead: true,
                on: true,
                dataIndx: ['CustomerName'],
                menuItems: ['grandSummary'],
                summaryInTitleRow: 'all',
                titleInFirstCol: true,
                fixCols: false,
                indent: 20,
                collapsed: [true],
                title: [
                    "{0} ({1})",
                    "{0} - {1}"
                ],
                useLabel: true
            }

5

Help for ParamQuery Grid (free version) / Re: Update the value of parent grid rows based upon nested records

« on: January 14, 2021, 11:45:47 am »

I am trying to update summary values using "summaryData". But that is not working. Find an example shown below and let me know if I am doing something wrong. Thanks

var jsonFormat= JSON.stringify(summaryColumnList);
$grid.option("summaryData", [ jsonFormat ]);
$.grid.refresh();

6

Help for ParamQuery Grid (free version) / Re: Update the value of parent grid rows based upon nested records

« on: January 14, 2021, 12:28:47 am »

I am able to update parent row based upon filtered nested grid using updateRow() method. Now I am facing the problem to update grand summary as par the updated rows of main grid. UpdateRow() method is not working to update summary row. can you suggest something?

7

Help for ParamQuery Grid (free version) / Re: Update the value of parent grid rows based upon nested records

« on: January 12, 2021, 11:14:00 am »

I tried to update parent row using nested grid filter option but didn't work. I want to change the value of main grid row based upon filtered nested rows. For your reference I am sharing my code.

filter: function (event, ui) {
       var grid = $(".vc-facility-detail").pqGrid('getInstance').grid; //instance of master grid
       grid.updateRow({ rowIndx: 0 });
}

Can you suggest something.

8

Help for ParamQuery Grid (free version) / Re: Update the value of parent grid rows based upon nested records

« on: January 12, 2021, 12:50:32 am »

I tried to update parent row within nested grid filter option but didn't work. For your reference I am share the code.

filter: function (event, ui) {
       var grid = $(".vc-facility-detail").pqGrid('getInstance').grid; //instance of master grid
       grid.updateRow({ rowIndx: 0 });
}

Can you suggest something.

9

Help for ParamQuery Grid (free version) / Update the value of parent grid rows based upon nested records

« on: January 09, 2021, 03:03:20 am »

I have parent grid rows are showing sum of their nested records. Nested grid has filter option. I want to ask If I filter nested grid records, is it possible to update parent grids rows accordingly. Can you suggest something?

10

Help for ParamQuery Grid (free version) / Re: Decimal values are not populated properly on excel

« on: January 04, 2021, 09:52:37 pm »

Can anyone from support team look into this issue?

11

Help for ParamQuery Grid (free version) / Decimal values are not populated properly on excel

« on: December 24, 2020, 01:45:30 am »

I am using format: '###,###.000' on colModel to show three place decimal number. It is showing properly on grid, but if the value is zero then it is not showing properly on export to excel. Can you suggest some solution.

12

Help for ParamQuery Grid (free version) / Re: Multiple values in one column cell

« on: December 23, 2020, 12:01:26 am »

Hi, I want to show multiple values in a cell and also want to do filter on that. Can you share your code. Thanks

13

Help for ParamQuery Grid (free version) / Re: How to not close nested child grid when refreshing parent grid.

« on: December 19, 2020, 01:01:04 am »

I am calling refreshDataAndView() on nested grid inorder to show updated value, but still struggling to show updated value on parent grid. I tried updateRow() but didn't work can you suggest something?

14

Help for ParamQuery Grid (free version) / Re: How to resize grid height if row is hidden

« on: December 17, 2020, 02:40:38 am »

Filtered nested grid.

15

Help for ParamQuery Grid (free version) / How to resize grid height if row is hidden

« on: December 17, 2020, 02:31:19 am »

I created the custom method to filter nested grid row and it will set row visibility to hidden, if search value does not match with row vale. it is working fine the only problem is when row is hidden I need to reset the grid height. For example in first image there are three row in the nested grid having region 30,30 and 35. When I am doing filter on 35 it will hide first two rows as shown in image two but showing blank space. I want to remove that blank space so that is will show only one nested record. As par my understanding i need to resize nested grid height. Can you help me out in this?