Creating a Subquery Filter Using a HOLD File

How to:

Create a Subquery Filter Using a HOLD File

You can create a subquery using a HOLD file. A subquery is a nested query that is added to the Where clause of an SQL statement. A subquery is valuable because it is highly reusable.

Procedure: How to Create a Subquery Filter Using a HOLD File

This procedure describes how to create a subquery filter using a HOLD file created in the previous procedure.

Build a report.
On the Data tab, in the Filter group, click Filter.

The Filter dialog box opens.
In the Create a filtering condition dialog box, from the Type drop-down menu, select Subquery as the filter type for the left-most part of the expression.
From the Subquery drop-down menu, select In list as the comparison operator.
From the list of subqueries, select the subquery that was created (in this example, File1) for the right-most part of the expression.
Click OK.

The report is filtered by the subquery that you created.

Note: To view the SQL statements generated by the request, go to the Quick Access Toolbar, open the Run drop-down menu, and select SQL Trace.

	WebFOCUS