I am setting filtering on the grid in code using:
$("#gridList").igGridFiltering("filter", ([{ fieldName: "VehicleReg", expr: myCriteria, cond: "contains", logic: "OR" }]));
This works ok. However sometimes the grid data will have spaces so the data may contain D123 456 and sometimes it maybe D123456. I am removing the spaces from the search criteria (myCriteria) so the criteria would always be D123456.
How would I set the filter so it would find the grid record in both cases?
Many thanks.Dave
For anyone interested I resolved this by creating an unbound column which is based on my VehicleReg field but with the spaces removed I can then filter based on this