Using GUIDE in DQL Mode › Selecting Guide Panels › Choose Components

Choose Components

You can choose to add one or more groups of panels to a basic query. The basic query only reads one table and prints all the data in the table. You can choose Guide panels that help you:

• Search two tables.
• Limit the search.
• Calculate data.
• Sort data for the report.

The following tells you where to read more about the Guide components that you can add to the base Guide query. When a panel appears as a result of selections you make on the GUIDED QUERY CREATION: OPTION SELECTION (DQHV0), turn to the section that matches its description.

To join two tables for data selection. (relationship clause)

Read the CA Dataquery Reference Guide.

To apply selection criteria to data selection. (WITH clause)

Read Step 3: Narrow the Search.
Step 4: Define Data Selection Conditions.

To tell CA Dataquery how to create data for the report from data found in the table (SET statement).

Step 5: Name a Temporary Result,

Step 6: Select Columns for Temporary Result Calculation,
Step 7: Calculate Temporary Result.

To sort the output data (SORT statement).

Read Step 8: Sort Data for the Report,
Step 9: Specify Sorting Priority and Control Breaks.