ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: queensgambit9 on February 21, 2018, 02:01:45 pm

Title: Render function
Post by: queensgambit9 on February 21, 2018, 02:01:45 pm

When using the render function to build column data (there is no actual data for it (no dataIndx), uses logic from other columns to build up data).
Would it be possible being able to filter on rendered data?, export works fine through column.exportRender...but can't filter the data...

Title: Re: Render function
Post by: paramvir on February 21, 2018, 05:37:06 pm

formula should be used instead of column.render to build column data.

Example: Profits column data is built from Total ( also a formula column ) and Expenditure. https://paramquery.com/pro/demos/grid_formula

filtering, sorting and export works on formula data.

Title: Re: Render function
Post by: queensgambit9 on February 22, 2018, 02:48:32 am

Thanks.
I experience a little slower performance when filtering formula columns, is it expected behaviour?

Title: Re: Render function
Post by: paramvir on February 22, 2018, 10:06:51 am

There shouldn't be much difference.

Please optimize your formula function for performance. Kindly share formula function or jsfiddle if you need any help with that.