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 Management2017.11

Administer > Database administration > Data persistence > Queries > Perform IR Expert queries

Perform IR Expert queries

Applies to User Roles:

System Administrator

You can perform an intelligent query using an information retrieval engine called the IR Expert utility. With this utility, you can accurately define queries for a list of helpful topics filtered from your search criteria.

To perform an IR Expert query on the probsummary table:

Click Tailoring > Database Manager.
Type =probsummary in the Form field, and then click Search.
On the incident search form, click Text Search.
In the Search Text area, type your search word(s).

Note: Be sure to insert a comma (,) or white space between your search words if you want to search for any of them. For example, type "computer, reboot" or "computer reboot".
Specify a search type:
- All of these words - search for records that contain all of your search words.
  For example, if you entered "web browser hangs" in the Search Text field on the incident search form, selecting this option will only search for incident records whose Description or Title field contains "web browser hangs".
- Any of these words - search for records that contain any of your search words.
  For example, if you entered "web browser hangs" in the Search Text field on the incident search form, selecting this option will search for incident records whose Description or Title field contains "web", or "browser" or "hangs".
  - Search only these words - search for your search words only;
  - Also search related words (slower) - search for your search words and also their related words.
Click Search.

Service Management displays the search results.

Send Help Center feedback