Creating multiple filter conditions
When you create a filter, you can define one or more filter conditions. Each condition you add narrows the scope of data further. For example, you can create a filter that returns rows where the customer’s credit rank is either A or B and whose open orders total between $250,000 and $500,000. Each condition adds complexity to the filter. Design and test filters with multiple conditions carefully. If you create too many filter conditions, the information object query returns no data.
Adding a condition
You use Filters, shown in Figure 2-13, to create one or more filter conditions. To create a filter condition, you choose New and complete the Filter Conditions dialog, shown in Figure 2-12. When you create multiple filter conditions, Information Object Query Builder precedes the second and subsequent conditions with the logical operator AND, for example:
SalesOffice LIKE 'San Francisco%' AND ProductLine LIKE 'Vintage Cars%'
This filter returns only data rows that meet both conditions. Sometimes, you want to create a filter to return data rows when either condition is true, or you want to create a more complex filter. To accomplish either task, use the buttons on the right side of Filters, shown in Figure 2-20.
If you create more than two filter conditions and use different logical operators, use the parentheses buttons to group conditions to determine the order in which they are evaluated. Display the query output to verify the results.
Figure 2-20  

Additional Links:

Copyright Actuate Corporation 2012