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 > Join Relationship

Join Relationship

A join relationship is a logical connection that represents the relationship between two CIs (and which appears only in the topology map containing the TQL query results). It does not exist in the CMDB. A join relationship is created by defining an attribute for each query node, whose values are used for comparison.

The TQL results retrieve all CIs whose attribute values meet the conditions defined in the join definition.

For example, you can create a join definition that links all node CIs connected to IP Address CIs whose Created By attribute values are equal (see the example below).

Each join definition represents one condition defined for the join relationship.

Note You can define multiple conditions.

For an example of a join definition, see How to Define a Join Relationship – Scenario. For details on defining join relationships, see Add/Edit Join Relationship Dialog Box.

Related Information

Send Help Center feedback