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 > Tailoring Best Practice Guide > Database (RDBMS) mapping > Example: Re-mapping an array > Existing array mapping

Existing array mapping

Suppose you want to re-map the assignment.groups array field in the operator table from a field in a main table array to a multi-row array table array. To ensure that your tailoring efforts do not negatively impact your system, you should first make a copy of the operator table. For example, create a new table called hpoperator.

The existing array might be mapped as follows on a Microsoft SQL Server RDBMS.

Existing array field mapping: field in main
Database dictionary field	Value
Name	assignment.groups
Type	array
Level	1
Index	88
SQL Name
SQL Type
SQL Table
SQL RC

Since this is a field in main table mapping, the array itself has no direct mapping on the RDBMS. Only the array's sub-field has a SQL mapping.

Existing sub-field mapping: field in main
Database dictionary field	Value
Name	assignment.groups
Type	character
Level	2
Index	1
SQL Name	ASSIGNMENT_GROUPS
SQL Type	TEXT
SQL Table	m1
SQL RC	False

The sub-field of the array is mapped to a character large object data type. For example, TEXT is a character large object data type in Microsoft SQL Server.

Send Help Center feedback