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"