Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Universal CMDB11.0

Use > Modeling > Introduction > Topology Query Language > Topology Query Language User Interface > Related Query Node Properties Page

Related Query Node Properties Page

This wizard page enables you to create an expression that restricts the number of query nodes that appear in the query by adding an attribute condition to a query node or relationship.

Important information

Each row represents an attribute condition that you specify. Use the And/Or column and the Brackets columns to link multiple conditions. In this way, you can construct a more precise logical statement to generate the required results.

When you access the wizard from the Modeling Studio, this wizard page has three tabs: Attribute, Element Type, and Element Layout. The Attribute tab includes the elements described below. For details on the Element Type tab, see Element Type Tab. For details on the Element Layout tab, see Element Layout Tab.

Wizard map

The Add Related Query Node Wizard contains:

User interface elements are described below:

UI Element (A-Z)	Description
	Add. Adds an attribute condition row. Select the attribute name, operator, and value to define the attribute condition.
	Delete. Deletes the selected attribute condition.
	Up. Moves a selected row up.
	Down. Moves a selected row down.
	Show Criteria. Displays the criteria of the selected condition in a pop-up dialog box.
And/Or	Click inside the And/Or field and select either And or Or to link multiple conditions.
Attribute name	Choose an attribute from the list.
Brackets	Click inside the Brackets box to display a list of brackets you can use to build more complex, logical statements.
Criteria	Contains the attribute condition definition as defined in the CI Instances Dialog Box.
Include subtypes	Display both the selected CI and its children in the topology map. Note This check box is only available in the Enrichment Manager and Impact Analysis Manager.
NOT	Select NOT if you want the condition statement to do the opposite of what is defined. Note If you select NOT, query results do not include data from the CI instances that were not assigned a value. For example, your system contains three nodes: Node1 is assigned the value A, Node2 is assigned the value B and Node3 is not assigned a value. You create a query to retrieve all nodes that are equal to A and select NOT; the results of your query only include Node2 because Node3 is not assigned a value.
Operator	Select the required operator. For details, see Attribute Operator Definitions.
Show element in query results	Select Show element in query results to display the selected TQL query node in the editing pane. When the check box is cleared, a Hidden in Query Results indicator appears to the right of the selected TQL query node in the editing pane. Any query results pertaining to that TQL query node are not displayed in the topology map. This can be useful when certain relationships or TQL query nodes are required to build the query but are not needed in the results. For example, Windows are connected to the network by defining specific IP Addresses, but in any query results you may want to view the IP Address elements only and not the Windows elements.
Value	Enter or select the value of the attribute. The Value options vary according to the attribute type you select.

Send Help Center feedback