setFilter( columnIndex, expression )

This method filters grid data by applying a filter expression to a specific column. The expression is not case sensitive. The filtered text may be highlighted. The highlighting can be cleared using the clearHighlighting() method on the grid.

Parameters:

• columnIndex - index to identify the column, where 0 is the first column, 1 is the second column, etc. For client-side filtering, a special value of "*all" can be specified, which triggers a filter on all columns.

• expression - expression to filter grid data, with the following syntax:

  • xyz - searches for all data containing 'xyz'

  • between aaa and zzz - searches for alphanumeric values between 'aaa' and 'zzz'

  • between 10 and 20 - searches for numeric values between 10 and 20 

  • starts with xyz - searches for all data that starts with 'xyz'

  • values A, B, C, etc. - searches for a list of values (exact matches)

  • jvalues [“x”,”y”,”z”] - same as “values”, above, except the list is a JSON array of strings.

  • =xyz - searches for data equal exactly to 'xyz'

  • >123 - greater than search

  • >=123 - greater or equal to search

  • <123 - less than search

  • <=123 - less than or equal to search

  • !=xyz - searches for alphanumeric values that do not contain 'xyz'

  • !=123 - searches for numeric values that are not equal to 123

*Column 0 refers to the first column as established during design-time (in Visual Designer). If