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 |
|
- List: RAD functions
- RAD function: add.graphnodes(xml)
- RAD function: cache.flush
- RAD function: clean.display.value
- RAD function: cleanup
- RAD function: contents
- RAD function: copyright
- RAD function: currec
- RAD function: current.device
- RAD function: current.format
- RAD function: cursor.field.contents
- RAD function: cursor.field.display.content
- RAD function: cursor.field.display.content.set
- RAD function: cursor.field.name.set
- RAD function: cursor.field.name
- RAD function: cursor.field.readonly
- RAD function: cursor.line
- RAD function: date
- RAD function: datecmp
- RAD function: day
- RAD function: dayofweek
- RAD function: dayofyear
- RAD function: dbdict.helper(“db.type”)
- RAD function: dbdict.helper(“field.type”)
- RAD function: dbdict.helper(“is.alias”)
- RAD function: dbdict.helper(“joinfile.names”)
- RAD function: dbdict.helper(“unique.key”)
- RAD function: delete
- RAD function: denull
- RAD function: descriptor
- RAD function: display.value.copy
- RAD function: evaluate
- RAD function: evaluate.query
- RAD function: evaluate_query
- RAD function: exists
- RAD function: fduplicate
- RAD function: filename
- RAD function: filequeryex
- RAD function: frestore
- RAD function: genout
- RAD function: get.base.form.name
- RAD function: get.dateformat
- RAD function: get.display.value
- RAD function: get.graph.action
- RAD function: get.graph.id
- RAD function: get.graph.target
- RAD function: get.graphnode.id
- RAD function: get.lock.owner
- RAD function: get.timezoneoffset
- RAD function: get.uid
- RAD function: gui
- RAD function: index
- RAD function: insert
- RAD function: iscurrent
- RAD function: isExpressionValid
- RAD function: isfileexist
- RAD function: jscall
- RAD function: lioption
- RAD function: lng
- RAD function: locks
- RAD function: logoff
- RAD function: logon
- RAD function: mandant
- RAD function: max
- RAD function: messages
- RAD function: min
- RAD function: modtime
- RAD function: month
- RAD function: multiselect.selection("fieldcontents")
- RAD function: multiselect.selection("fieldname")
- RAD function: multiselect.selection("rows")
- RAD function: multiselect.selection("selected")
- RAD function: multiselect.selection("selections")
- RAD function: multiselect.selection("tablename")
- RAD function: null
- RAD function: nullsub
- RAD function: operator
- RAD function: option
- RAD function: parse
- RAD function: perf
- RAD function: printer
- RAD function: policyread
- RAD function: processes
- RAD function: prof
- RAD function: recordcopy
- RAD function: recordtostring
- RAD function: round
- RAD function: same
- RAD function: scmsg
- RAD function: set.display.value
- RAD function: set.timezone
- RAD function: setsort
- RAD function: shutdown
- RAD function: simple.file.load
- RAD function: sleep
- RAD function: str
- RAD function: stradj
- RAD function: strchrcp
- RAD function: strchrin
- RAD function: strclpl
- RAD function: strclpr
- RAD function: strcpy
- RAD function: strdel
- RAD function: strins
- RAD function: strpadl
- RAD function: strpadr
- RAD function: strraw
- RAD function: strrep
- RAD function: strtml
- RAD function: strtrmr
- RAD function: substr
- RAD function: substrb
- RAD function: sysinfo.get("ActiveFloatUsers")
- RAD function: sysinfo.get("Active Licenses")
- RAD function: sysinfo.get("ActiveNamedUsers")
- RAD function: sysinfo.get("AuthMode")
- RAD function: sysinfo.get("ClientNetAddress")
- RAD function: sysinfo.get("ClientOSName")
- RAD function: sysinfo.get("ClientPID")
- RAD function: sysinfo.get("ClientVersion")
- RAD function: sysinfo.get("Display")
- RAD function: sysinfo.get("Environment")
- RAD function: sysinfo.get("languagecode")
- RAD function: sysinfo.get("MaxFloatUsers")
- RAD function: sysinfo.get("MaxLicenses")
- RAD function: sysinfo.get("Mode")
- RAD function: sysinfo.get("PrevLabel")
- RAD Function: sysinfo.get("PKMode")
- RAD function: sysinfo.get("PrintOption")
- RAD function: sysinfo.get("Quiesce")
- RAD function: sysinfo.get("RecList")
- RAD function: sysinfo.get("ServerNetAddress")
- RAD function: sysinfo.get("ServerNetPort")
- RAD function: sysinfo.get("ServerPID")
- RAD function: sysinfo.get("ThreadID")
- RAD function: sysinfo.get("TotalFloatUsers")
- RAD function: sysinfo.get("TotalLicenses")
- RAD function: sysinfo.get("TotalNamedUsers")
- RAD function: sysinfo.get("TotalProcs")
- RAD function: sysinfo.get("TotalSystemProcs")
- RAD function: sysinfo.get("TotalUserProcs")
- RAD function: time
- RAD function: tod
- RAD function: tolower
- RAD function: toupper
- RAD function: translate
- RAD function: trunc
- RAD function: type
- RAD function: updatestatus
- RAD function: val
- RAD function: version
- RAD function: year
RAD function: index
A RAD function that returns the index or position number for the value of a specific element in an array or a character in a string. If the target value is not in the array or string, NULL is the return.
Function
index
Format
index(target value, $variable, starting position #)
Parameters
The target value
variable is the value you are searching for in the array or string.
The $variable
variable is the name of the variable to be searched.
The starting position #
variable is the index in the array or position in the string where the search will begin. The default value is 1
).
Factors
- The index() function operates identically for arrays, regardless of the data type in the array.
-
If the array is composed of structures or of arrays, the target variable must exactly match the structure or array.
For example, the function does not allow selecting a field from a structure.
-
You can use the index function to search for any value by converting both the value and the search variable to the same type.
For example, if you want to search for the
$problem.number
variable on all forms, you could pass the following query to the select panel:index(“$problem.number”, str(field))
The index function searches for the
$problem.number
variable in thefield
field of the format table. -
When you use the index() function in a query, Service Manager evaluates the function based on database case sensitivity.
For example, if you use the Expert Search option on the Incident Management search screen, and search for
index(“Windows Server”, brief.description) > 0
:- On a case insensitive database, the query returns all records where the
brief.description
field containswindows server
orWINDOWS SERVER
orWindows SERVER
, and so on. - On a case sensitive database, the query only returns records where the
brief.description
field contains exactlyWindows Server
.
- On a case insensitive database, the query returns all records where the
-
When you use the index() function in a RAD or JavaScript expression and not within a query, Service Manager evaluates it case sensitively (regardless of the database setting).
For an example, consider the following RAD or JavaScript expressions:
- The expression
index(“Windows Server”, {“WINDOWS SERVER”, “windows server”})
, returns 0. - The expression
index(“Windows Server”, {“WINDOWS SERVER", “Windows Server”, “windows Server”})
, returns 2.
- The expression
Example
index(1,{1,2,3})
returns 1
index(2,{1,2,3})
returns 2
index(1,{1,2,3},2)
returns 0
index(2,{1,2,3},2)
returns 2