ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: pranit@srcomsec on January 18, 2023, 08:21:37 pm

Title: summary data in Grid query for dynmic columns
Post by: pranit@srcomsec on January 18, 2023, 08:21:37 pm

We need the summary data in the grid but the column position cannot fix, I mean the dynamic column with different column index for any column in the grid.

As per your sample article below, here you set hardcode (revenues:'sum(C:C)'). We need to set "C:C" dynamically based on the column index. Please advise
https://paramquery.com/pro/demos/summary_json

Title: Re: summary data in Grid query for dynmic columns
Post by: pranit@srcomsec on January 19, 2023, 01:31:24 pm

Any update on this?

Title: Re: summary data in Grid query for dynmic columns
Post by: paramvir on January 19, 2023, 05:37:09 pm

you can get the letter corresponding to column index by pq.toLetter method:

https://paramquery.com/pro/api#method-toLetter

Title: Re: summary data in Grid query for dynmic columns
Post by: pranit@srcomsec on January 20, 2023, 05:40:46 pm

Thank you. Working great!!