I have a grid where one column is being passed a json object in the form
'trial' : {
'name': 'trial-123',
'link': {
'objectId': 'object-123',
'value': 'link-text'
}
}
I’m using a custom cellsrenderer function to use this object to build an anchor to link to another page. This is working fine.
I also need to filter this column based on the value of the trial.name field, but with default filtering options, the json object appears to have toString() called on it before the filter text is checked, so basically unless the filter starts with “[Object object]”, the filter check always fails.
The best I can do to apply this custom filtering is to bind to the ‘filter’ event, clear the non-working filter, and then manually build up a filter to be applied again:
var filtergroup = new $.jqx.filter();
var filtertype = 'custom';
var trialFilter = function(filterValue, cellValue, condition ) {
console.log('in custom filter');
return cellValue.name.toUpperCase().indexOf(filterValue.toUpperCase()) == 0;
}
var filter = filtergroup.createfilter(filtertype, filterText, 'starts_with', trialFilter);
filtergroup.addfilter(1, filter);
gridElement.jqxGrid('addfilter', 'trial', filtergroup, trialFilter);
This obviously is super inefficient. How can I properly add custom filtering to a column whose column data is a json object?
Thanks,
-Dan
