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 > How to Define a Complex Type Condition - Scenario

How to Define a Complex Type Condition - Scenario

This section describes how to define a complex type condition in the Query Node Properties dialog box. In this example, you add subtype conditions to a Node query node in a TQL query.

To define a complex type condition:

Create a TQL query and drag a query node of type Node onto the editing pane.
Right-click the query node and select Query Node Properties. The Query Node Properties dialog box opens.
Select the Element Type tab and select Customize subtypes.
In the CI Types pane, select Computer, and in the Conditions pane, select Exclude <Computer> from the query. Select the Apply this condition recursively on all subtypes of <Computer> check box. This excludes all CIs of type Computer and its descendants in the query results.
In the CI Types pane, select Unix, and in the Conditions pane, select Include <Unix> in the query. This includes all Unix CIs in the query results.
In the CI Types pane, select IBM Frame, and in the Conditions pane, select Include <IBM Frame> in the query. Then select By qualifiers and select the CONTAINER qualifier. This includes all IBM Frame CIs with the CONTAINER qualifier in the query results.
In the CI Types pane, select Firewall, and in the Conditions pane, select Exclude <Firewall> from the query. Select By qualifiers and select the HIDDEN_CLASS and MAJOR_APP qualifiers. This excludes all Firewall CIs with the HIDDEN_CLASS and MAJOR_APP qualifiers from the query results.
Click OK to save your conditions and exit the dialog box.

Related Information

Send Help Center feedback