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 > Use case: Incident Analyst

Use case: Incident Analyst

As an Incident Analyst, I would like to show interactions that have an incident attached that is in open status.

Task 1. Configure the relationship between interaction and incident.

Log on as a system administrator.
From the command line, enter db and then press the Execute Command button.
In Form enter relatedObjectMap and then click the Search button.

Type the following values in the corresponding fields and then click the Search button .

Field	Value
Source Table:	`incidents`
Source Field:	`incident.id`

Click Delete to delete the relation between incident and incdepends, which is not used in the Inbox.

Type the following values in the corresponding fields and then click the Add button.

Field	Value
Source Table:	`incidents`
Source Field:	`incident.id`
To Table:	`screlation`
To Field:	`source`

Type the following values in the corresponding fields and then click the Add button.

Field	Value
Source Table:	`screlation`
Source Field:	`depend`
To Table:	`probsummary`
To Field:	`number`

Log out of Service Manager.

Task 2: Create the view

Log in as a system administrator.
Switch to the Interaction queue.
Click More or the More Actions menu, and then click Define Views.
Click New.
In the name field, type the following, choose System View, and the click Next:
```
All interactions that have an open incident attached
```
Click Next.
Click Filter, click Advanced Filter, and then click Add New Filter Criteria.
In Field in Interaction, select Interaction ID, and then click Use Multi Level Field Chooser.
Select field Depend for screlation, and select Status for Incident.
Click Next.
Set Comparison to Equals, set Value to Open, and then click Next.
Click OK.
Click Fields.

Specify the following values in the corresponding fields and then click Add to List.

Field	Value
Interaction	Interaction ID
screlation	Depend
Incident	Status

Specify the following values in the corresponding fields and then click Add to List.

Field	Value
Interaction	Interaction ID
screlation	Depend

Click Finish and then click Apply View.

After you complete these tasks, you can log in as an Incident Analyst, and then switch to the “All interactions that have an open incident attached” view.

Send Help Center feedback