Searching the Help
To search for information in the Help, type a word or phrase in the Search box. When you enter a group of words, OR is inferred. You can use Boolean operators to refine your search.
Results returned are case insensitive. However, results ranking takes case into account and assigns higher scores to case matches. Therefore, a search for "cats" followed by a search for "Cats" would return the same number of Help topics, but the order in which the topics are listed would be different.
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 |
|
|
Either word in a topic |
|
|
Topics that do not contain a specific word or phrase |
|
|
Topics that contain one string and do not contain another | ^ (caret) |
cat ^ mouse
|
A combination of search types | ( ) parentheses |
|
Remap array fields to an alias table
To improve your query performance, you can move an existing array field or an array of structure field to an alias table (for example, a1).
- The " field in alias" and "BLOB in alias" mapping formats are deprecated. The multi-row array mapping format is recommended.
- You can revert your remapping changes by moving the field back to the main table and restoring the original SQL configuration.
Array
You can remap an array field to an alias table using the multi-row array mapping format.
To remap an array field using the multi-row array mapping format, follow these steps:
- Log in to the Service Manager Windows client as a system administrator.
- Type dbdict in the command line, and press Enter.
- Open the dbdict that you want to update by performing a search.
- Select the Fields tab.
- Select the field of the array type, and click Edit Field/Key.
-
Enter a value in the fields as described in the following table.
Note As an example, the following table lists the SQL Type values allowed for an array of characters. For other types of arrays, the allowed SQL Type values may differ.
Mapping format SQL Name SQL Type SQL Table SQL RC Multi-row array MULTI_ROW_ARRAY TEXT, varchar, char, nvarchar, or nchar a1 False -
Click OK.
Array of structure
To remap an array of structure using the multi-row array mapping format, follow these steps:
- Log in to the Service Manager Windows client as a system administrator.
- Type dbdict in the command line, and press Enter.
- Open the dbdict that you want to update by performing a search.
- Select the Fields tab.
-
In the array of structure, select the top level field (whose type is array), change its SQL Table field value to a1 and leave the rest of the fields empty.
-
Select the middle level field (whose type is structure), and make sure its SQL Name, SQL Type, and SQL Table fields are empty.
-
Select each element under the structure, and enter a value in the fields as described in the following table.
Note As an example, the following table lists the SQL Type values allowed for a structure element of the character data type. For elements of other data types, the allowed SQL Type values may differ.
SQL Name SQL Type SQL Table SQL RC <FIELD_NAME_1> TEXT, varchar, char, nvarchar, or nchar a1 False -
Click OK.
Related concepts
Existing array mapping
Existing array query performance
Prepare to remap the array