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)`

Configuration Management System (CMS)2018.05

Use > Modeling > Introduction > Topology Query Language > How to Add Query Nodes and Relationships to a TQL Query

How to Add Query Nodes and Relationships to a TQL Query

This section explains how to add query nodes and relationships to a TQL query. It is relevant for Impact Analysis Manager, Enrichment Manager, and the Modeling Studio.

Note For TQL queries to be valid, they must comply with certain restrictions. For details, see Troubleshooting and Limitations – Topology Query Language.

To add query nodes and relationships to a TQL query:

In Impact Analysis Manager or Enrichment Manager, select the required query from the tree in the left pane or click the New button to create one.

In the Modeling Studio, select the Resources tab in the left pane, select Queries as the Resource Type, and select the required query from the tree or click New > Query to create a new one.
In Impact Analysis Manager or Enrichment Manager, click and drag one or more required TQL query nodes from the tree displayed in the CI Type Selector, onto the editing pane. In the Modeling Studio, select the CI Types tab in the left pane and drag the required TQL query nodes from the tree onto the editing pane. These are the TQL query nodes that are included in the query.

If you want the query to run over federated CIs also, right-click a query node and select Set Integration Points. In the Select Integration Points dialog box, select the integration points for the external data sources to use. For details, see Select Integration Points Dialog Box.
To add a relationship between two query nodes, do one of the following:
- Select the required TQL query nodes by holding the CTRL key and clicking the TQL query nodes, right-click and select Add Relationship. The Add Relationship dialog box opens. Select the required relationship. For details, see Add/Edit Relationship Dialog Box.
- Click the Create Relationship icon and draw a line between the required query nodes. The Select Relationship Type dialog box opens. Select the required relationship type. For details, see Select Relationship Type Dialog Box.
Click OK. The selected query nodes are linked by the relationship you have selected.

Related Information

Send Help Center feedback