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