Use > Modeling > Introduction > Topology Query Language > Attribute Operator Definitions

Attribute Operator Definitions

This section contains a list of operators used to define attribute conditions in various dialog boxes, such as the Subgraph Condition dialog box, Impact Rules Definition dialog box, or the Query Node/Relationship Properties dialog box.

Operator Description
Changed during (Displayed only when you select an attribute of type Date.) Displays only the instances that changed during the period specified in the Value box.
Equal Checks whether the attribute value is equal to the value specified in the Value box.
Equal ignore case

Checks whether the attribute value is equal to the value specified in the Value box regardless of the case.

Note When working with Microsoft SQL Server, this option is identical to Equal.
Greater

Checks whether the attribute value is greater than the value specified in the Value box.

Note When comparing attributes of type string, the comparison is based on the ASCII values of the string characters.
Greater than or equal Checks whether the attribute value is greater than or equal to the value specified in the Value box.
In Displays only the instances where this attribute value equals one of the selected values. For example, for CIs that have a Change state that equals Plan and New, select the operator In from the Operator list and select both Plan and New from the Value box.
In ignore case

Displays only the instances where this attribute value equals one of the selected values, regardless of the case.

Note When working with Microsoft SQL Server, this option is identical to In.
Is null Checks whether the attribute value is null.
Less

Checks whether the attribute value is less than the value specified in the Value box.

Note When comparing attributes of type string, the comparison is based on the ASCII values of the string characters.
Less than or equal Checks whether the attribute value is less than or equal to the value specified in the Value box.
Like Uses a wildcard (%). Use Like when you are not sure of the complete name for which you are searching.
Like ignore case

Uses a wildcard (%). Use Like ignore case when you are not sure of the complete name for which you are searching. The case of the string is ignored.

Note When working with Microsoft SQL Server, this option is identical to Like.
Not equal Checks whether the attribute value is not equal to the value specified in the Value box.
Occurs after (Displayed when you select a date type attribute.) Displays only the instances that occurred after the period specified in the Value box.
Occurs within (Displayed when you select a date type attribute.) Displays only the instances that occurred within the period specified in the Value box.
Unchanged during (Displayed when you select a date type attribute.) Displays only the instances that did not change during the period specified in the Value box.

Note

  • For the Not equal operator, query results do not include data from the CI instances that are not assigned a value. For example, a system contains three nodes: Node1 is assigned the value A, Node2 is assigned the value B, and Node3 is not assigned a value. If you create a query to retrieve all nodes that are Not equal to A, the results of your query include Node2 only, because Node3 is not assigned a value.

  • Universal CMDB supports both Microsoft SQL Server and Oracle Server databases. Microsoft SQL Server is not case sensitive by default (unlike Oracle database which is case sensitive). Consequently, if you are using Microsoft SQL Server, the Equal operator retrieves the same query results as the Equal ignore case operator. For example, if you select the attribute City, the operator Equal, and type NEW YORK in the Value comparison box, case differences are ignored and query results include NEW YORK, New York and new york.

Send Help Center feedback