filter->conditions compare to use other data

[jplevene]

In the "compare" I only have access to (cellData, val1, val2), however I need to also take into account data in other other columns as my filter column is rendered using multiple data sources.

How can I do this, besides completing the column data externally.

Code: [Select]

filter: {
    conditions: {
        range: {
            compare: function(cellData, val1, val2) {
                // need to access ui here to get other column data
            }
        }
    }
}

[paramvir]

however I need to also take into account data in other other columns as my filter column is rendered using multiple data sources.

column.render callback is incorrect choice to update cell value.

Please use rowTemplate getter or js formulas to set up dependencies of a column value on other column values.

[jplevene]

This won't work as we build the contents using live and changing data that is shared between tables. 

Also for speed improvements we have turned off spread sheet functions due to the number of rows, as well as other reasons.

Also the help for rowTemplate has no details or examples.

[paramvir]

js formulas are different from spreadsheet functions.

Following are the examples for js functions and rowTemplate respectively:

https://paramquery.com/pro/demos/grid_formula

https://paramquery.com/pro/demos/rowtemplate