Render function

[queensgambit9]

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...

[paramvir]

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.

[queensgambit9]

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

[paramvir]

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.