Creating Group Filters

Filters enable you to conditionally remove records selected by your queries.

Groups can have two types of filters:

  • Expression — Create an expression using predefined functions and operators

  • PL/SQL Function — Create a custom filter

  1. Click Menu, and then select Create Group Filter.

    The Edit Group Filter dialog is displayed as shown below.

  2. Select the Group Filter Type: Expression or PL/SQL.


    For PL/SQL filters, you must first specify the PL/SQL Package as the Oracle DB Default Package in the data model properties. See Setting Data Model Properties.

  3. Enter the Filter:

    • To enter an expression, select the elements and click the shuttle button to move the element to the Group Filter definition box. Click the predefined functions and operators to insert them in the Group Filter box.

      SeeFunction Reference for a description of the available functions.

      Click Validate Expression to ensure that the entry is valid.

    • To enter a PL/SQL function, select the PL/SQL package from the Available box and click the shuttle button to move the function to the Group Filter box.

      Your PL/SQL function in the default package must return a Boolean type.

After you have added the group filter, the data set object displays the filter indicator, as shown below.

  1. Click Menu for the data set.
  2. Choose the appropriate action:
    • To edit the group filter, choose Edit Group Filter to launch the Group Filter dialog for editing.

    • To delete the group filter, choose Delete Group Filter.