Page History

...

1. AND/OR Logic - define the logic used between each filter condition.
2. Bracket Arrows - the addition of brackets around sets of filters allows for more complex logic, used in conjunction with AND/OR logic settings.
3. Filter Fields - the fields added to the Filters list in order to restrict the report results.
4. Operator Selection - select the operator to be used in the filter, specifying how values will need to match, or differ from the condition defined.
5. Value Selection - either define a value for the filter condition, or set it as User Prompt for the report reader to define.
6. Filter Logic - displays a summary of the filters.
7. Add Filters - allows the user to add more fields to the filters list without closing the configuration panel
8. The item that has been selected on the report data page for filtering. E.g. Last Name
9. The Operator drop down lets you select what type of filter to be used. For example Last Name is Not Null or Equal To.
10. The brackets allow for greater complexity in data filtering by using AND and OR with the where clause operator.
11. The filter data displays what the filter is to be. If you have selected specific data to filter on it will be displayed here. The default - USER PROMPT this allows the user to set the filter prior to running a report. Use the Prompt icon to browse available values.
12. This allows the user to set multiple filters and join them using AND or OR. For example filter all People where AGE is Greater than 50 or Gender = Female.
13. The move up and down buttons allows the user to build complex bracketing filters. The level of a statement within the bracket will affect the overall filter statement and impact upon the data returned in the query.
14. The filter logic display allows a user to read a summary of the filter that they have defined.

Filter Logic or Operator

...