Filter
Filter option enables you to define criteria for the query, restricting data to be displayed.
977bbcc8-a212-4124-81d8-ea5e9bdaa027Important: You can create a filter from a Branch of your choice. |
Procedures
To build a filter:
| 1. | In Queries, click Filter. |
The system displays the Filter Expression screen.
| 2. | Based on the fields Fields, Operators and Expression, the user may build the filter to restrict information to be queried. |
Example:
To display only records of Bank 383, the following operation must be defined:
Field |
Operator |
Operating |
Bank |
equal to |
383 |
| 3. | After operation elements are selected, click Add. |
The selected elements are displayed in the Filter area.
| 4. | To enter one or more operations, use options to form logical operations: |
Options |
Description |
( ) |
It is used to group operations, establishing order of execution. |
and |
The system allows information of more than one expression for building the filter. When AND operator is used, only those records that meet two or more specified conditions are displayed. |
or |
The system allows information of more than one expression for building the filter. When OR operator is used, records that meet any of specified conditions are displayed. |
Examples:
Suppliers from the State SP whose type is J.
(State is equal to SP) and (Type is equal to J)
Thus, the system will build the expression in the area Expression. If there are errors building the expression, click Clear Filter to start again.
| 5. | Click Expression if you want to define the condition for the query using an AdvPl expression. |
Example:
AdvPl Expression: SUBSTR(A1_COD,3,3)=“001”
| 6. | The system displays the screen for entering the expression. Enter it. |
Then, click Add to move the expression to the Filter area, or Cancel to return to the filter generation screen.
| 7. | To finish the filter, click OK. |
The system displays only filtered information in query window.