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

Service Manager9.50

Administer > Database Administration > Data persistence > Queries > Cross-table join query improvements > Cross-table join query examples and use cases

Cross-table join query examples and use cases

The following examples detail various scenarios in which you will see the benefits of the cross-table join queries:

Use case: Incident Analyst

Use case: Department manager

Use case: JavaScript Developer

Example: Query two tables

Example: Query more than two files

Example: Sort

Example: Count

Example: Handle two files that have the same field name

Example: Handle BLOB, CLOB, text and images

Example: Handle a one-to-many relationship

Note The table alias are mandatory for cross-table query. For example, select pro.* from probsummary pro is correct, whereas select probsummary.* from probsummary is incorrect.

Reserved words

Reserved words have a special meaning in Service Manager that is defined in RAD. These special words can only be used for that purpose. Do not use them for any other purpose such as field names or table alias. The following is an alphabetical list of reserved words:

AND, BEGIN, DO, ELSE, END, FALSE, FOR, IF, IN, ISIN, NOT, NULL, OR, STEP, WHILE, THEN, TRUE, UNKNOWN, INNER, OUTER, JOIN, ON, SELECT, AS, FROM, WHERE, ASC, DESC, BETWEEN, GROUP, BY, HAVING, LIKE, TABLE, VIEW, WHERE, MIN, MAX, AVG, COUNT, SUM, ID.

In addition, all the RAD and JavaScript function names, and standard SQL reserved word in Oracle, SQL Server, or DB2 are similarly reserved.

Send Help Center feedback