Build complex filter expressions using MaxBasic. Filters constructed using the Filter tab write the expression for the Advanced tab. You can start by selecting a simple filter in the Filter tab, then further refine the filter in the Advanced tab. When you start editing a filter in the Advanced tab, the Filter tab becomes unavailable.
See also Filter & Sort.
|
Operators |
A menu of all the filter operators available in advanced filters. |
|
Field Names |
The valid fields available to include in the filter expression. You can build the filter expression by selecting from the Operators and Field Names menus. |
|
Functions |
Lists available MaxBasic functions that can be used in the filter expression. |
|
Help |
Lists available MaxBasic help topics, and links to the help text. |
|
Check Syntax |
Checks all field names are correctly specified and the use of operators valid. Invalid filters cannot be saved. |
|
Clear Filter |
Clears the filter expression and makes the Filter tab available for building a simple filter. |