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"

Unable to render {children}. This macro only works on pages.