Combining Filter Conditions

Overview

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 on 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.

Once combined, however, you can determine how the conditions work together by bracketing them together and changing the logical operators that specify how the conditions are combined.

Logical operators

Logical operators let you specify how you want conditions combined. Yellowfin filters allow two types of logical operators:

1. The AND logical operator combines two conditions into a narrower condition. A data item must meet the first condition and the second condition to meet the condition's requirements.
2. The OR logical operator combines two conditions into a broader condition. A data item can meet the first condition or the second condition to meet the condition's requirements. For example return clients where their last name = Smith or their Gender = Female.
   To switch between the AND operator and the OR operator, select the value from the drop down list box.

Bracketing conditions

If you've combined at least three conditions in your query, you can bracket certain conditions to bind them together. You use this the same way you might use parentheses to change the value a in the following arithmetic equations:

a = 36 * (6 +12) as opposed to a = (36 * 6) + 12

For example, you want information about the Events or People in the system on a particular day.

1. To create a bracket, select the line that you wish to bracket and click the bracket icons (initially the right pointing arrow). This will indent the line and create the bracket condition. To view the result of the bracket read the statement in the filter logic section below the filter attributes table.
2. To change the level of the bracket you can use the move up and move down links to change the order of your filter attributes in the statement.