Apply Advanced Grid Filters
- Last UpdatedMar 11, 2022
- 3 minute read
To add or change an advanced (complex) Filter to the current grid view, in the Grid Actions section of the Home Tab click Filter. The Filter window is then displayed:
Add a New Criteria
Select the Field by entering or selecting a value from the list of fields in the Field option.
Select a Filter Criteria from the list of criteria in the Criteria option.
Enter a value in the Value option, or select from the list of values in the Value option.
Add Additional Criteria
Select Join + Filter from the toolbar.
Change the default 'AND' logical join to 'OR' by clicking on the blue 'AND' text that appears between filter records.
Enter the Field, Criteria and Value information of the additional criteria as required. Any number of additional criteria may be defined.
The toolbar can be used to change the order of filter criteria and to add brackets around them. See below for more information on the toolbar, and on filter criteria.
Apply the Filter
To apply the Filter, click Apply.
Note:
Some filter criteria such as 'Begins With' use a wild card match to filter values.
Do not supply any wild card characters such as '*' or '%' as the application handles
this automatically.
More Information about Filter Criteria
|
Filter Criteria |
Description |
Example Value |
Comments |
|
Exact Match |
Field = Value |
1234 |
Shows all records where Field = 1234 |
|
Begins With - Partial Match |
Field like XX* |
XX |
Shows all records where Field begins with two characters XX |
|
Ends With - Partial Match |
Field like *XX |
XX |
Shows all records where Field ends with two characters XX |
|
Contains - Partial Match |
Field like *XX* |
XX |
Shows all records where Field contains two characters XX |
|
In List |
Field = A or B or C |
A, B, C |
Shows all records where Field exact matches any values in list |
|
Greater Than Or Equal To |
Field ³ Value |
1234 |
Shows all records where Field ³ 1234 |
|
Less Than |
Field < Value |
1234 |
Shows all records where Field < 1234 |
|
Less Than Or Equal To |
Field £ Value |
1234 |
Shows all records where Field £ 1234 |
|
Greater Than |
Field > Value |
1234 |
Shows all records where Field > 1234 |
|
Not Exact Match |
Not Field = |
1234 |
Shows all records where Field does not = 1234 |
|
Not Begins With Partial_Match |
Field like T |
T |
Shows all records not beginning with T |
|
Not Ends With Partial_Match |
Field like T |
T |
Shows all records not ending with T |
|
Not Contains Partial_Match |
Field like T |
T |
Shows all records not containing T |
|
Is Empty |
Is Field = (nothing) |
Shows all records where Field is empty |
|
|
Not Empty |
Not Field = (nothing) |
Shows all records where Field is not empty (no characters) |
|
|
Not Null |
Not Field = Null |
Shows all records where Field is not Null |
Note:
A database NULL means nothing has ever been entered in this field, whereas Empty means that current value is empty (no characters).
Command Buttons
|
Apply |
Exits the Filter window and applies the filter to the current grid. |
|
Cancel |
Exits the Filter window without changing any filters in the current grid. |
Toolbar Commands
|
+ Filter |
Adds a new Filter row to the Filter definition |
|
- Filter |
Removes the selected Filter row from the filter definition |
|
Change Join |
Toggles the selected logical join between AND and OR |
|
+ ( |
Adds a left bracket to the filter expression |
|
- ( |
Removes a left bracket from the filter expression |
|
+ ) |
Adds a right bracket to the filter expression |
|
- ) |
Removes a right bracket from the filter expression |
|
- ( ) |
Removes all brackets |
|
Test Filter |
Tests the Filter |
|
Up |
Moves a Filter row up |
|
Down |
Moves a Filter row down |
|
Clear Filters |
Clears all filters in the current grid |