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 |
|
- Link maintenance
- Data relationships and the link file
- Types of links
- Find functionality
- Fill functionality
- Fill functionality with multi-select
- Turn off multi-select functionality
- Virtual joining functionality
- Us.link
- Variables used in links
- Calling the us.link
- Skipping query writing
- Accessing $File/dates
- Find from and fill to a $ variable
- Find from and fill to an array structure
- The $fill.display and $fill.display.add functionality
- Access the link record
Skipping query writing
Service Manager performs the “Fill” action based on the query defined in the link line to filter data against the target table. Prior to Service Manager 9.41, you usually defined the query by ID.
As of Service Manager 9.41, a Skip Query Rewriting option is available on the Edit Link Line form. This option is added as part of the logical name solution, which adds the display.name field to the device table to store CI names.
Note For more information about the logical name solution, see the Service Manager Logical Name Solution white paper.
Because CI names are now stored in the display.name field instead of the logical.name field, Service Manager by default automatically rewrites your existing link queries at runtime to address the impact of the logical name solution (the Skip Query Rewriting option is disabled by default). If the Skip Query Rewriting option is enabled, the system does not perform the additional operations that it does when the option is not enabled.
To access this option, open a link record in Database Manager, highlight a link line and then select the Select Line option from the More menu. By default, this option is disabled.
Guidelines on editing link queries for a reference field
When writing a link query for a reference field, you need to observe different guidelines depending on whether this option is enabled or disabled.
Note The following descriptions use affected.item as an example reference field.
-
If the Skip Query Rewriting option is not enabled, update an expression such as “
logical.name#affected.item in $File” to the following:logical.name#\""+affected.item in $File+"\"" -
If the Skip Query Rewriting option is enabled, you must write a query like the following:
if (not (null(get.display.value($File, "affected.item")))) then $query+=(" and display.name#\""+get.display.value($File, "affected.item")+"\"")
Additionally, as a system administrator, you need to understand how the Fill function works for a reference field:
- The “affected.item in $File” expression will be null when the user types something in the format, and the system gets what the user has typed by the “get.display.value” function.
- If the Skip Query Rewriting option is not enabled, the system assigns what the user has typed to “affected.item in $File” when the user clicks the Fill button, and then rewrites at runtime the evaluated “$query” from, for example, “logical.name# DISPLAY VALUE” to “display.name# DISPLAY VALUE”. This makes the original link query still work for the reference field.
Related concepts
Link maintenance
Types of links
Find functionality
Fill functionality
Virtual joining functionality
Us.link
Variables used in links
Find from and Fill to a $ variable
Find from and Fill to an array structure
