ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: SureshB on August 24, 2016, 07:37:57 pm

Title: How to get summary Data after grouping the rows.
Post by: SureshB on August 24, 2016, 07:37:57 pm

Hi

I have a situation that I grouped the rows with summary type Max. It is working well.

But , I need the grouped summary max value in render function of the cells for further calculations.

How can i get the grouped summary max value of a column , when even i need.

Thank you.

Title: Re: How to get summary Data after grouping the rows.
Post by: paramvir on August 24, 2016, 09:47:57 pm

That's simply available as ui.cellData inside render callback.

http://paramquery.com/pro/api#option-column-render

Also grouping adds few properties to the rows i.e., pq_gtitle, pq_gsummary, pq_grandsummary, pq_level, pq_close for easy identification of group title, summary rows and their current state in rowData, which can be used inside render callback.

http://paramquery.com/pro/api#option-groupModel

var rd = ui.rowData;
if( rd.pq_gtitle || rd.pq_gsummary ){
  //do something with ui.cellData.
}

Title: Re: How to get summary Data after grouping the rows.
Post by: SureshB on August 25, 2016, 08:29:59 pm

Hi ,

Is this functionality available in PQGrid 2.x?

I could not get the  rd.pq_gtitle || rd.pq_gsummary  Properties.

Thank you.

Title: Re: How to get summary Data after grouping the rows.
Post by: paramvir on August 26, 2016, 10:11:45 am

It's available in >= v3.3.0