Filtering data rows

Databases typically contain vast amounts of data. Reports, however, typically use a small subset of the data, so SQL queries often contain filter conditions to limit the rows returned.

How to filter data rows

1	Choose Conditions.

2	Create a filter condition.

1	In Column, select a column or Build Expression to create an expression.

2	In Operator, select an operator.

3	In Value, select a column or type a value.

4	In AND/OR, optionally select AND or OR to specify another filter condition.

Figure 2-7 shows an example of a filter condition.

Figure 2-7

Filter condition on data rows

The following WHERE clause is added to the SELECT statement in the top pane:

WHERE CLASSICMODELS.ORDERS.ORDERDATE > '2004-06-30'

Copyright Actuate Corporation 2012