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

Develop > Developer Reference > Creating Discovery and Integration Adapters > Developing Generic Database Adapters > TQL Queries for the Generic Database Adapter

TQL Queries for the Generic Database Adapter

For population jobs, every required layout of a CI must be checked in the Layout Settings Dialog Box in the Modeling Studio. For details, see Query Node/Relationship Properties Dialog Box. It is important to note that a CI might require an attribute to be identified, and without those attributes the CI will fail to be added to UCMDB.

The following limitations exist on the TQL queries calculated by the Generic Database Adapter only:

subgraphs are not supported
compound relationships are not supported
cycles or cycle parts are not supported

The following TQL query is an example of a cycle:
Function layout is not supported.
0..0 cardinality is not supported.
The Join relationship is not supported.
Qualifier conditions are not supported.
To connect between two CIs, a relationship in the form of a table or foreign key must exist in the external database source.

Send Help Center feedback