Specifying the evaluation order
Information Object Query Builder evaluates filter conditions in the order in which they appear. You can change the order by selecting a filter condition in Filters, shown in Figure 2-20, and moving it up or down using the arrow buttons. Filter conditions that you type in the Actuate SQL text box, shown in Figure 2-14, are preceded by AND and are evaluated last.
If you define more than two conditions, you can use parentheses to group conditions. For example, A AND B OR C is evaluated in that order, so A and B must be true or C must be true for a data row to be included. In A AND (B OR C), B OR C is evaluated first, so A must be true and B or C must be true for a data row to be included.
The following examples illustrate the difference a pair of parentheses makes.
The following filter contains three ungrouped conditions:
Country IN ('Australia', 'France', 'USA') AND SalesRepNumber = 1370 OR CreditLimit >= 100000
Figure 2-21 shows the first 10 data rows returned by the query. Although the filter specifies the countries Australia, France, and USA and sales rep 1370, the data rows display data for other countries and sales reps. Without any grouped conditions, the filter includes rows that meet either conditions 1 and 2 or just condition 3.
Figure 2-21  
The following filter contains the same three conditions, but this time the second and third conditions are grouped:
Country IN ('Australia', 'France', 'USA') AND (SalesRepNumber = 1370 OR CreditLimit >= 100000)
Figure 2-22 shows the first 10 data rows returned by the query. The Country IN ('Australia', 'France', 'USA') condition must be true, then either the SalesRepNumber = 1370 condition or the CreditLimit >= 100000 condition is true.
Figure 2-22  
Changing a condition
You can change any of the conditions in Filters.
How to change a filter condition
In Filters, shown in Figure 2-20, select the filter condition. Choose Edit.
In Filter Conditions, shown in Figure 2-12, modify the condition by changing the values in Filter by, Operator, or Value. Choose OK.

Additional Links:

Copyright Actuate Corporation 2012