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 > Join Relationship Condition Dialog Box

Join Relationship Condition Dialog Box

This dialog box enables you to define the connection between two query nodes using a join relationship.

To access	In Enrichment Manager or Impact Analysis Manager, click the Add button in the Add Join Relationship dialog box.
Important information	You cannot select attributes of type list for a join relationship condition.
Relevant tasks	How to Define an Impact Rule – Workflow How to Define an Enrichment Rule – Scenario How to Define a TQL Query Implement a Discovery Adapter

User interface elements are described below (unlabeled elements are shown in angle brackets):

UI Element (A-Z)	Description
<Selected query node1>	A selected query node. The first attribute applies to <end_1>.
<Selected query node2>	A selected query node. The second attribute applies to <end_2>.
Operator	Select one of the following operators: Equal. The system checks whether two selected attributes are equal. Not equal. The system checks whether two selected attributes are not equal. Sub string. The system checks whether the value of the first attribute is a substring of the value of the second attribute. Sub string ignore case. The system checks whether the value of the first attribute is a substring of the value of the second attribute regardless of the string's case. Note When using the operator Not equal, ensure that both sides of the join relationship have a limited result size. It is recommended to define more specific conditions so as not to overload the system with large results.

UI Element (A-Z)

Description

<Selected query node1>

A selected query node. The first attribute applies to <end_1>.

<Selected query node2>

A selected query node. The second attribute applies to <end_2>.

Operator

Select one of the following operators:

Equal. The system checks whether two selected attributes are equal.
Not equal. The system checks whether two selected attributes are not equal.
Sub string. The system checks whether the value of the first attribute is a substring of the value of the second attribute.
Sub string ignore case. The system checks whether the value of the first attribute is a substring of the value of the second attribute regardless of the string's case.

Note When using the operator Not equal, ensure that both sides of the join relationship have a limited result size. It is recommended to define more specific conditions so as not to overload the system with large results.

Send Help Center feedback