Create Group Filters

Create group filters to conditionally remove records selected by your queries.

Group filters work for columns within the dataset group elements. Group filters might not work for expression elements and elements from other dataset groups.

Groups can have two types of filters:

• Expression — Create an expression using predefined functions and operators
• PL/SQL Function — Create a custom filter

After you add a group filter, the dataset object displays the filter indicator.

To create group filters:

1. Click Menu, and then select Create Group Filter.
2. Select the Group Filter Type: Expression or PL/SQL. For PL/SQL filters, ensure that you specify the PL/SQL Package as the Oracle DB Default Package in the data model properties.
3. Enter the Filter:
   • To enter an expression, select the elements and move the elements to the Group Filter definition box. Click the predefined functions and operators to insert them in the Group Filter box.

     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 move the function to the Group Filter box.

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