Defining Filters in Composite Queries
Use the Composite Query Manager page - Filters section and the Add / Edit Filter page (PSCPQFILTERDTL_SEC) to view, define, and maintain query filters for the selected output fields in the composite queries.
Navigation
Select Reporting Tools, Composite Query, Composite Query Manager.
Create a new composite query or open an existing one.
In the Composite Query Manager page - Fields section, click the Actions icon and select the Add Filter option from the Action list.
Field or Control |
Definition |
---|---|
Condition Type |
Select a value from the Condition Type drop-down list. The available options are greater than, not greater than, less than, not less than, equal to, not equal to, in list, and not in list. |
Criteria Type |
Select a value from the Criteria Type drop-down list. The available options are:
|
To add filters to composite queries:
Select Reporting Tools, Composite Query, Composite Query Manager.
Open an existing composite query or create a new one.
In the Composite Query Manager page - Fields section, click the Actions icon for the output field that you want to add as a filter and select the Add Filter option.
Alternatively, in the Query Selected section, click the Actions icon for the field that you want to add as a filter and select the Add Filter option.
The Add / Edit Filter page appears, enabling you to create a filter against the selected field.
Select a value from the Condition Type drop-down list.
The available options are greater than, not greater than, less than, not less than, equal to, not equal to, in list, and not in list.
Select the values in the Filter Expression - Right section.
Select a value from the Criteria Type drop-down list.
The available options are Expression, Field, Prompt, and Constant.
Select a value from the Expression 2 Text section.
This value is used for creating the filter with the selected field in the Filter Expression - Left section.
Click the OK button to create the filter.
The Composite Query Manager page - Filter section appears, listing the newly added filter.
To add a filter for an expression in a composite query:
Select Reporting Tools, Composite Query, Composite Query Manager.
Open an existing composite query.
In the Composite Query Manager page, Expressions section, click the Menu icon for the expression that you want to add a filter to and select the Add Filters option.
Alternatively:
In the Composite Query Manager page, Expressions section, click the Menu icon for the expression to which you want to add a filter.
Select the Add Field option to add the expression to the output field list.
In the Fields section, click the Actions icon for the expression field that you want to add a filter to and select the Add Filter option.
Use the Add/Edit Filters page to select the condition type, criteria type, and field (or prompt, expression, constant) to create the filter.
Click the OK button to accept the changes and return to the Composite Query Manager page.
The newly added filter is listed in the Composite Query Manager page on the Filters tab.
Specify the filter logical properties as needed.
Save the composite query.
To edit filters in composite queries:
Select Reporting Tools, Composite Query, Composite Query Manager.
Open an existing composite query.
In the Composite Query Manager page, click the Filters button.
The Filters section appears.
Click the Actions icon for the filter that you want to edit and select the Edit option.
The Add / Edit Filter page appears.
Specify filter properties such as condition type, criteria type, and expression 2 text.
Click the OK button to accept the changes.
The Composite Query Manager page - Filter section reappears, listing the filter with the new settings.
To remove filters from composite queries:
Select Reporting Tools, Composite Query, Composite Query Manager.
Open an existing composite query.
In the Composite Query Manager page, click the Filters button.
The Filters section appears.
Click the Actions icon for the filter that you want to remove.
Select the Remove option.
The selected filter is removed from the Filters section.
When your composite query includes multiple filter criteria, you may group filter criteria with parentheses to define how filter criteria should be evaluated. For example, filter criteria inside the parentheses are evaluated before the filter criteria outside the parentheses.
Use the Edit Filter Grouping page (PSCPQFILTERGRP_SEC) to edit the filter grouping in a composite query.
Field or Control |
Definition |
---|---|
Group Selected |
Click this button to add the parentheses around the selected filters. |
UnGroup Selected |
Click this button to remove the parentheses around the selected filters. |
Reset All |
Click this button to remove all parentheses that currently exist in the Filters section. |
Steps Used to Group Filter Criteria in Composite Queries
To group the filter criteria in composite queries:
Select Reporting Tools, Composite Query, Composite Query Manager.
Open an existing composite query.
In the Composite Query Manager page, click the Filters button.
Click the Group Filter button to access the Edit Filter Grouping page.
Select the filters that you want to group together.
Click the Group Selected button to add the parentheses around the selected filters.
The selected filters are grouped using parentheses.
Click the OK button to apply the changes to the filters.
The Composite Query Manager page - Filter section reappears showing the grouped filters.