Page History

Anchor
top top

Table of Contents
class contents

Overview

Styleclass
Class topLink

...

Filter Settings

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

Styleclass
Class topLink

...

Filter Settings

You can combine conditions to increase control over the data a report contains. Combining conditions lets you retrieve data that, for example, contains the people Smith or Johnson, or concerns female clients. Whenever you have more than one condition in a report, Yellowfin automatically combines them with an And. All you have to do to combine conditions is add them to your filter list.

...

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

Operator

Styleclass
Class topLink

...

Filter Settings

The operator defines how values will be matched to the filter. For example, In List will return results as long as a value matches one of the ones in the list. The options within the drop down will vary based upon the type of field that the filter is to be applied to.

See Filter Operators for more information.

Value

Styleclass
Class topLink

...

Filter Settings

There are different options available when it comes to filter values. As a report writer you can choose to set:

...

See Filter Values for more information.

 

horizontalrule

Styleclass
Class topLink

...

Filter Settings

 

 

...