Grid String Filtering

[Simon WilliamsParticipant]

Hi

I have been through the documentation and there does not appear to be a ‘not_equal’ comparison operator for strings? Is this deliberate? If so, is there another way I can filter rows where a cell value is ‘not-equal’ to a condition value.

[DimitarParticipant]

Hi Simon Williams,

There is a filter condition ‘NOT_EQUAL’, but it is only applicable to numeric and date filters. For string filters, you can try using ‘DOES_NOT_CONTAIN’ or ‘DOES_NOT_CONTAIN_CASE_SENSITIVE’. You can try these in the demo Filtering.

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[Simon WilliamsParticipant]

Thanks Dimitar

I have seen these operators. However, they are slightly different.

For example ‘DOES_NOT_CONTAIN’ <ABC> will filter out:

ABC
ABC1
ABCD

‘NOT_EQUALS’ <ABC> will only remove <ABC>.

Is this something you are able to implement in the future or do I need to look at an alternative solution? E.g. custom filter.

[DimitarParticipant]

Hi Simon Williams,

Thank you for your suggestion. We will consider adding this condition, but we do not currently plan to do so.

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[Author]

Posts