Panels › (DQH70) Selection Criteria: Define Condition

(DQH70) Selection Criteria: Define Condition

 =>
 
 --------------------------------------------------------------------------DQH70
 DATAQUERY: SELECTION CRITERIA: DEFINE CONDITION    QUERY NAME: _______________
 -------------------------------------------------------------------------------
 Define the condition by selecting a comparison operator and a value to compare
 with  ________________________________  in  ________________________________
 
 Select one comparison operator:
 
 _ Equal (EQ)       _ Greater than (GT)             _ Less than (LT)
 _ Not equal (NE)   _ Greater than or equal (GTE)   _ Less than or equal (LTE)
 _ Containing
 
 Enter values for comparison with ________________________________
 
 _______________________________________________________________________________
 _______________________________________________________________________________
 _______________________________________________________________________________
 _______________________________________________________________________________
 
 -------------------------------------------------------------------------------
 <PF1> HELP          <PF2> RETURN         <PF3> REPEAT COLUMN <PF4> CONTINUE
 <PF5> EXTEND COLUMN <PF6> DISPLAY QUERY  <PF7> NOT USED      <PF8> NOT USED

Description

In DQL Mode, the optional Guided Query Selection Criteria: Define Condition panel appears for every column selected as a Selection Criteria column in the previous step. With it, you describe the data you want to be searched for in a column to qualify a row for inclusion in your report.

In a query, you can specify a selection criteria clause with the format WITH operand1 operator operand2. You selected operand1 with the Selection Criteria: Designate Columns (DQH60) panel. With this panel, you select the operator and operand2. The operand2 parameter can be a column or key name, a value, or a logical expression that follows the rules for specifying operand2 found in the chapters on query syntax. An introduction to using this panel appears in the CA Dataquery User Guide.

Action

Choose a comparison operator from the panel by entering a character next to the one that indicates how you want to compare the found column values to the values you enter at the bottom of the panel. You can choose only one operator.

Your entries on the blank lines provided must follow the rules for specifying comparisons in DQL WITH clauses found in the chapters on query syntax. When the panel is complete and correct, press Enter or <PF4> CONTINUE to go to the next step.

Display Fields

Refer to the following for explanations of the display fields intended to contain variable data.

QUERY NAME:

The name you assigned this query.

compare with __

The key or column selected for comparison of the values you enter on this panel.

in ___

The name of the table containing the selected column.

Select

Make selections on this panel according to the following.

Equal (EQ)

Data in the column must be equal to the value you enter below for the row to be selected.

Greater than (GT)

Data in the column must be greater than the value you enter below for the row to be selected.

Less than (LT)

Data in the column named must be less than the value you enter below for the row to be selected.

Not equal (NE)

Data in the column named must not match the value you enter below for the row to be selected.

Greater than or equal (GTE)

Data in the column must be greater than or equal to the value you enter below for the row to be selected.

Less than or equal (LTE)

Data in the column named must be less than or equal to the value you enter below for the row to be selected.

Containing

Data in the column named must contain the value you enter below in the positions indicated by the value statement.

Entering Comparison Values

On the lines following "Enter values for comparison with", enter any valid comparison value, following the rules for specifying operand2 of CA Dataquery selection criteria in the chapters on query syntax.

PF Keys

The following lists the PF keys for this panel, with a brief description of each function.

<PF1> HELP

Displays Help information about the current panel.

<PF2> RETURN

Returns to the Selection Criteria: Designate Columns (DQH60) panel.

<PF3> REPEAT COLUMN

Lets you use the same column again in another comparison.

<PF4> CONTINUE

Displays the next Guided Query panel when this one is complete.

<PF5> EXTEND COLUMN

Displays the extended column definition for key or column.

<PF6> DISPLAY QUERY

Displays the query created so far.