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.
Words and Phrases
| 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. |
Using Boolean Operators
| 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 |
|
Database dictionary data types
Service Manager uses the following data types to describe field data.
| Data type | Purpose | Typical RDBMS mapping |
|---|---|---|
| Number | Assumes field data consist of numeric data. | Service Manager maps number fields to RDBMS data types reserved for numerical data, such as FLOAT or NUMBER. |
| Character | Assumes field data consist of alphanumeric characters (numbers, letters, special characters). | Service Manager maps character fields to RDBMS data types reserved for alphanumeric data, such as VARCHAR or VARCHAR2. |
| Date/time | Assumes field data contain a Service Manager formatted date or time. Service Manager date/time formats include:
|
Service Manager maps date/time fields to RDBMS data types reserved for date/time data, such as TIMESTAMP or DATE. |
| Logical | Assumes the field data contain one of the following logical values: true, false, NULL or unknown. Logical fields accept yes or no values for input, but the server converts them to true or false values when stored. | Service Manager maps logical fields to RDBMS data types reserved for single character data, such as CHAR. |
| Array | The field data are compound data elements that contain one or more elements of a single data type or a structure field. | Service Manager maps array fields to RDBMS data types reserved for character large object (CLOB) data, such as TEXT. |
| Structure | The field data are compound data elements that contain several subfields, each of which may have a different data type. Structures must be child elements of an array field. | Service Manager maps structure fields that are within an array field to RDBMS data types reserved for binary large object (BLOB) data, such as IMAGE. |
| Expression | The field data contain parsed Rapid Application Development (RAD) language expressions. | Service Manager maps expression fields to RDBMS data types reserved for binary large object (BLOB) data, such as IMAGE. |
| Label | The field data contain system data used and are not intended for customer data. | Service Manager does not map label fields to any RDBMS data type. |
| Record | The field data contain system data and are not intended for customer data. | Service Manager does not map record fields to any RDBMS data type. |
Related topics
Database dictionary
Database dictionary data types
Database dictionary records
Add a field to an existing database dictionary record
Update the data type of a database dictionary field
