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 |
|
- Cross-table join query examples and use cases
- Use case: Incident Analyst
- Use case: Department manager
- Use case: JavaScript Developer
- Example: Query two tables
- Example: Query more than two files
- Example: Sort
- Example: Count
- Example: Handle two files that have the same field name
- Example: Handle BLOB, CLOB, text and images
- Example: Handle a one-to-many relationship
Use case: Incident Analyst
As an Incident Analyst, I would like to show interactions that have an incident attached that is in open status.
Task 1: Configure the relationship between interaction and incident.
-
Log on as a system administrator.
-
From the command line, enter dband then press the Execute Command button.
-
In Form enter
relatedObjectMapand then click the Search button. -
Type the following values in the corresponding fields and then click the Search button .
Field Value Source Table: incidentsSource Field: incident.id -
Click Delete to delete the relation between
incidentandincdepends, which is not used in the Inbox. -
Type the following values in the corresponding fields and then click the Add button.
Field Value Source Table: incidents Source Field: incident.idTo Table: screlation To Field: source -
Type the following values in the corresponding fields and then click the Add button.
Field Value Source Table: screlation Source Field: dependTo Table: probsummary To Field: number -
Log out of Service Manager.
Task 2: Create the view
-
Log in as a system administrator.
-
Switch to the Interaction queue.
-
Click More or the More Actions menu, and then click Define Views.
-
Click New.
-
In the name field, type the following, choose System View, and the click Next:
All interactions that have an open incident attached
-
Click Next.
-
Click Filter, click Advanced Filter, and then click Add New Filter Criteria.
-
In Field in Interaction, select Interaction ID, and then click Use Multi Level Field Chooser.
-
Select field Depend for
screlation, and select Status forIncident. -
Click Next.
-
Set Comparison to Equals, set Value to Open, and then click Next.
-
Click OK.
-
Click Fields.
-
Specify the following values in the corresponding fields and then click Add to List.
Field Value Interaction Interaction ID screlation Depend Incident Status -
Specify the following values in the corresponding fields and then click Add to List.
Field Value Interaction Interaction ID screlation Depend -
Click Finish and then click Apply View.
After you complete these tasks, you can log in as an Incident Analyst, and then switch to the “All interactions that have an open incident attached” view.
