Query Conditions (dmqry0502m000)

Use this session to specify the condition for processing a query. This session can be invoked in two ways:

To enter a new query condition, click New on the File menu, and enter the parameter values.

You can also specify one or more query conditions for each query, using the query connectors And or Or.

Each record in this session represents a condition on the query object for a specific query instance. Each query condition consists of a connector, an attribute, an operator, an optional system parameter, and a value. If the system parameter is selected, click the browse arrow to select the system parameter from the System Parameters (dmcom0125m000) session.

Note

Use the Group command to change the object type and query, if required.

 

Object
The object ID that acts as an identifier. The query instance is selected for the object type and the conditions for a query can be defined.
Query
The query ID which acts as identifier for the query. The conditions are specified for the query selected here.
Connector
The condition connector that represents the logical connection of a query condition with the earlier conditions.
Note

The first condition is blank by default. From the second condition connector onwards, the accepted values are either And or Or.

Attribute
The object attribute, which is the actual object of table field name. Attributes enable you to link the query conditions by using the two connectors, such as AND, OR. If the query object type is Change (CH), the object attribute must be cpid instead of dmchm011.cpid. You can either specify an attribute or click the browse arrow to select the field from the Table Fields (ttadv4529m000) session. After you specify the object attribute, the attribute's description appears. To select an attribute you want to include in the condition, use the browse arrow in the Internal Name column, and select the required attribute.
Operator
The logical operator quantifies the object attribute with a comparison operator. Select an operator from the drop-down list. The following table shows the usage of the available operators.
OperatorSyntaxInt. / LongFloat / DoubleEnumDateString
= / <>Single StringValueValueEnum Descriptionutc formatSingle String
> / >=Single StringValueValueEnum Descriptionutc formatSingle String
</ <=Single StringValueValueEnum Descriptionutc formatSingle String
IN / NOT INX[,Y] [,Z] …ValueValueEnum Descriptionutc formatSingle String
BET / NOT BETX and YValueValueEnum Descriptionutc formatSingle String
LIKE / NOT LIKEString. *Not ValidNot ValidNot ValidNot ValidString.*

 

Select an operator from the drop-down list in the operator column. A wide range of operators are available, for example, (Not) Equal, (Not) less than, (Not) like, & (Not) in, and so on.

Example "Release date > 06091991".

Note

The term "Single String" defines a continuous string without any breaks or spaces. For the "LIKE" operator, the sample string must be followed by ".*". If the selected object attribute is based on an enumerated domain, the user must provide a valid enum description from the domain. For example, if the selected object attribute is based on the domain dmcom.ynin, a valid value is "Yes" or "No". To specify dates, click the browse arrow and select a date from the date calendar.

System Parameter
If this check box is selected, you must fill the Value field with the available values from the System Parameters (dmcom0125m000) session .

Example: User Login code, UTC date/time.

Value
The value for the selected attribute.
Note

For the system parameter attribute, you must select the value from the System Parameters (dmcom0125m000) session.

For a date or enumeration attribute, you must select the browse arrow to specify the date from the date calendar.

For a enumeration attribute, you must select the value from the Enumeration values of the attribute.

 

Execute Query
Runs the query based on the specified condition.