Filter Option





Presents an option to filter grid data when the grid heading is right-clicked.

Promptable? DROPDOWN
Possible Values: true,false
Bindable? YES
Products: ProfoundUI

Filtering Expressions

The following is a list of possible filtering expressions that you can use when filtering a column: 

  • 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)

  • =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



As of version 6.9.1, blanks can now be filtered, and are represented by a single space. Valid expressions include: " ", "= ", "== ", and "values A, ,B"