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.41

Develop > Operational Reports Guide > Create and Edit Your Own Reports > Important Crystal Report Notes > OOB Reports Dependency

OOB Reports Dependency

Some OOB reports depend on the Join (table joindefs) and ERD (table erddef) definitions. If the definitions do not exist, you must define them so that you can preview these OOB reports successfully. See the tables below for a summary of the reports and their dependency on the Join and ERD definitions.

Reports Requiring ERD Definition
Report Name	First Filename	Second Filename	Relationship Type	Field Names from First Filename	Field Names from Second Filename
Escalated Interactions	incidents	screlation	One to One	incident.id	source
Knowledge Management Activity	kmdocument	kmusagehistory	One to Many	id	kmid
Knowledge Management Summary	kmdoctype	kmdocument	One to Many	name	doctype
SLM: Response SLO Metrics	sla	slaresponse	One to Many	agreement.id	agreement.id
SLM: Summary	sla	slaresponse	One to Many	agreement.id	agreement.id
SLM: Availability-Duration Metrics	sla	slamonthly	One to Many	agreement.id	agreement.id
SLM: Availability-Uptime Metrics	sla	slamonthly	One to Many	agreement.id	agreement.id

Reports Requiring Join Definition
Report Name	Join Table Name	File Names
Escalated Interactions	incidents-screlation	incidents screlation
Knowledge Management Activity	kmdocument-kmusagehistory	kmdocument kmusagehistory
Knowledge Management Summary	kmdoctype-kmdocument	kmdoctype kmdocument
SLM: Response SLO Metrics	sla-slaresponse	sla slaresponse
SLM: Summary	sla-slaresponse	sla slaresponse
SLM: Availability-Duration Metrics	joinslamonth	sla slamonthly
SLM: Availability-Uptime Metrics	joinslamonth	sla slamonthly

Send Help Center feedback