Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
585
igGridFiltering ignore spaces
posted

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

  • 585
    Offline posted

    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