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: get.display.value
This RAD function returns the display value of a field in a Service Manager file.
Function
get.display.value
Format
get.display.value($file, $fieldname, [index], [bForceFromDB])
Parameters
The following parameters are valid for this function.
Parameter |
Description |
---|---|
$file |
The $file variable is the file from which you want to retrieve the display value. |
$fieldname |
The name of a field in the file. Caution You cannot use a variable for this parameter. For example, |
[index] |
This parameter is optional. If the field specified in $fieldname is of the array type, the index is the position number of an element in the array where the element is located. If the index is not specified or is -1, the entire array is retrieved instead. |
[bForceFromDB] |
This parameter is optional. This is a Boolean type variable, which can be true or false. If it is true, this function will bypass the internal display value cache associated with $file, and retrieve the display value directly from the RDBMS. |
Factors
If an internal display value cache does not already exist, a null value is returned; however, if bForceFromDB is set to true, the Service Manager server looks for the display value directly from the RDBMS according to the current field value.
For an array type field, if bForceFromDB is set to true, this function combines the value in the display value cache (if any) and the value fetched directly from the RDBMS, and returns the combined value.
For a string type field, if bForceFromDB is set to true, while the Service Manager server cannot find any value from the RDBMS, the value in the display value cache (if any) is returned instead.
There are two ways to create an internal display value cache associated with $file:
- Use the set.display.value function explicitly.
- Any time when users enter or change the display value from the client side and the client submits the request to the server side, the internal display value cache is updated. This is automatic and not under the user’s control.
Return values
Can be null, a string type display value, or an array of string type display values.
Examples
function testDisplayValue() { var sql = 'select * from cm3r where number="C10008"'; var file = new SCFile('cm3r'); var rc = file.doSelect(sql); print( "Field value of assets=" + file.assets ); print( "Field value of logical.name=" + file.logical_name ); var darray = new SCDatum(); darray.push( "aaa" ); darray.push( "bbb" ); print( "Value of darray=" + darray ); system.functions.set_display_value(file, "assets", darray, -1 ); var value = system.functions.get_display_value(file, "assets" ); print( "get.display.value for assets from internal display value cache=" + value ); value = system.functions.get_display_value(file, "assets", -1, true ); print( "get.display.value for assets from RDBMS=" + value ); value = system.functions.get_display_value(file, "logical.name" ); print( "get.display.value for logical.name from internal display value cache=" + value ); value = system.functions.get_display_value(file, "logical.name", -1, true ); print( "get.display.value for logical.name from RDBMS=" + value ); } testDisplayValue();
This example returns the following results:
Field value of assets=[C++ object Datum] - {"CI1000984", "CI1000988"}
Field value of logical.name=CI1000984
Value of darray=[C++ object SCDatum] - {"aaa", "bbb"}
get.display.value for assets from the internal display value cache=[C++ object Datum] - {"aaa", "bbb"}
get.display.value for assets from the RDBMS=[C++ object Datum] - {"adv-Windows-101", "adv-Windows-102", "aaa", "bbb"}
get.display.value for logical.name from the internal display value cache=null
get.display.value for logical.name from the RDBMS=adv-Windows-101