Filter Settings

Overview

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.

Logic

Between each filter there is an AND / OR drop down option the user can define. This allows the user to define how the combination of multiple filters should work together to return results.

For example:

If you want to return all the records you have that have and Active Booking Status AND have either a Booking Method of Web Site OR Media Category of WebView the following would be defined:

Brackets have been placed around the Booking Method and Media Category filters to enclose the OR.

See Filter Operators for more information.

Operator

Value

User Prompt

Defined Value

Pre-Defined Date Range