Previous TopicNext Topic


How to filter at the data set level

  1. Choose Data Explorer.
  2. Choose the plus sign (+) beside Data Sets to expand it.
  3. Right-click the data set whose rows you want to filter, then choose Edit.
  4. Edit Data Set appears. It shows the query for the data set.

  5. Choose Filters from the left pane.
  6. Edit Data Set displays filter information.

  7. Specify the filter condition:
    1. Click in the cell below Expression.
    2. Two buttons appear on the right. The arrow button displays a list of fields you can use in Expression. The ellipsis (...) button launches Expression Builder, which you can use to create a more complex expression.
    3. For Expression, specify the filter expression.
    4. For Operator, select an operator from the drop-down list.
    5. For Value 1, specify the value to search. You can type the value, select from the list of values, or use Expression Builder to create a more complex value expression.
    6. If you select the Is True, Is False, Is Null, or Is Not Null operator, you do not specify a value.
    7. For Value 2, specify a value only if you select the Between or Not Between operator.
    The following illustration shows some examples of filter conditions.

  8. Choose Preview Results to verify the results returned by the data set.
  9. You should see only rows that match both filter conditions. To display rows that match either filter condition, create a single filter condition that contains an OR expression, then select the Is True operator..

(c) Copyright Actuate Corporation 2006

Previous TopicNext Topic