Filter Editor enables the user to filter data (display items which meet specific requirements) by constructing filter criteria in graphical form. Filter Editor should be used mainly for creating complex filter criteria, consisting of multiple conditions. Simple filter criteria can be created easily by using column’s drop down lists or by entering a filter value to a column’s header.
Condition groups can be used to create sets of conditions combined by the same logical operator.
To add a condition:
-
Click Add Condition
for the group.
Or
Click the logical operator of the group and select Add Condition
.
To add a group:
-
Click the logical operator of the group and select Add Group.
To delete a condition:
-
Click Remove Condition
.
Or
Select the condition and press DELETE key.
To delete a group:
-
Click the logical operator of the group and select Remove Group.
To delete all conditions:
-
Click the topmost logical operator and select Clear All.
Example of creating complex filter criteria with multiple logical operators
-
Click Filter
to expand Filter Editor.
-
Clear existing filter conditions by clicking Remove Condition
.
-
Change the root logical operator to OR by clicking current AND operator and selecting OR.
-
Add a new group by clicking OR operator and selecting Add Group.
-
Set the column of the created condition to Due Date and the operator to DateTime Operator, IsTomorrow.
-
Click AND operator and select Add Condition to add a new condition to the current group. Alternatively click
next to AND operator.
-
Set the column of the new condition to Thickness operator to Equals and operand value to 10,00.
-
Add a new group by clicking OR operator and selecting Add Group.
-
Set the column of the created condition to Due Date and operator to DateTime Operator, IsToday.
-
Click the new AND operator and select Add Condition to add a new condition to the current group. Alternatively click
next to AND operator.
-
For the new condition, set the column to Thickness, operator to Equals and operand value to 9,00.
-
Click Search
to search from database with the new filter criteria.
Database window will list orders with thickness of 10,00 millimeters, due date tomorrow and orders with thickness of 9,00 millimeters, due date today.