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: policyread
A RAD function that reads the data policy from a datadict table.
Function
policyread
Format
$L.returnvalue = policyread( $L.file/$filename, fieldname, fieldsetting)
Parameters
The following parameters are valid for this function.
Parameter |
Description |
$L.returnvalue |
The policy value returned after it is read from the database. It can be a string, a boolean, or null. |
$L.file/$filename |
This can be either a file variable or a file name: $L.file - The file handle of the table for which the data policy information is to be read from the database. It can be a join table, a normal table or an adhoc table. Note: Other kinds of tables (merge files, etc.) are not supported. $filename – The name of the table for which the data policy information is to be read from the database. It can be a normal table only. Note: All other kinds of tables are not supported. The table name is the value in the Name field in the datadict record. |
fieldname |
The name of the field in the specified table for which the data policy information is to be read from the database. The field name is the value in the Field Name field in the datadict record. |
fieldsetting |
The field setting on the specified field for which the data policy information is to be read from the database. If no field setting is passed in when calling policyread function, the function will return true if the field exists in data policy, otherwise will return false. This is one of the fields on Field Settings tab of the datadict record. Valid field settings are: "invisible", "readonly", "mandatory", "captions", "avail","encrypt", "defaults", "globallist", "matchfields", "matchfiles", and "validations", â€typesâ€, “reference.tableâ€. In addition, there two special settings: “display.fieldâ€, “autocomplete.show.fieldâ€, if one of these settings is specified, the field name will be ignored. |
Factors
If the fieldsetting is not in the list of Field Settings in the datadict table, the server will throw an error message. In any other case, this function returns a valid value or null.
Return values
A String, Boolean or null value.
Examples
Example 1
This example demonstrates how you could use a JavaScript to access the data policy on a simple file, such as the operator table.
// Access DataPolicy definition on operator file. var operatorFile = new SCFile( "operator" ); var rteReturn; rteReturn = system.functions.policyread( operatorFile , "profile.change", "invisible" ); print( "DataPolicy on (file:operator, fieldname:profile.change), as defined in (file:datadict, field:invisible) " + rteReturn ); rteReturn = system.functions.policyread( operatorFile , "profile.change", "readonly" ); print( "DataPolicy on (file:operator, fieldname:profile.change), as defined in (file:datadict, field:readonly) " + rteReturn ); rteReturn = system.functions.policyread( operatorFile , "profile.change", "mandatory" ); print( "DataPolicy on (file:operator, fieldname:profile.change), as defined in (file:datadict, field:mandatory) " + rteReturn ); rteReturn = system.functions.policyread( operatorFile , "profile.change", "captions" ); print( "DataPolicy on (file:operator, fieldname:profile.change), as defined in (file:datadict, field:captions) " + rteReturn ); rteReturn = system.functions.policyread( operatorFile , "profile.change", "avail" ); print( "DataPolicy on (file:operator, fieldname:profile.change), as defined in (file:datadict, field:avail) " + rteReturn ); rteReturn = system.functions.policyread( operatorFile , "profile.change", "encrypt" ); print( "DataPolicy on (file:operator, fieldname:profile.change), as defined in (file:datadict, field:encrypt) " + rteReturn ); rteReturn = system.functions.policyread( operatorFile , "profile.change", "defaults" ); print( "DataPolicy on (file:operator, fieldname:profile.change), as defined in (file:datadict, field:defaults) " + rteReturn ); rteReturn = system.functions.policyread( operatorFile , "profile.change", "globallist" ); print( "DataPolicy on (file:operator, fieldname:profile.change), as defined in (file:datadict, field:globallist) " + rteReturn ); rteReturn = system.functions.policyread( operatorFile , "profile.change", "matchfields" ); print( "DataPolicy on (file:operator, fieldname:profile.change), as defined in (file:datadict, field:matchfields) " + rteReturn ); rteReturn = system.functions.policyread( operatorFile , "profile.change", "matchfiles" ); print( "DataPolicy on (file:operator, fieldname:profile.change), as defined in (file:datadict, field:matchfiles) " + rteReturn ); rteReturn = system.functions.policyread( operatorFile , "profile.change", "validations" ); print( "DataPolicy on (file:operator, fieldname:profile.change), as defined in (file:datadict, field:validations) " + rteReturn );
Example 2
This example demonstrates how you could use a JavaScript to access the data policy on a complex file, such as a join of the incidents and contacts tables.
// Access DataPolicy definitions on join file inccontacts (incidents and contacts) var incident_contacts_file = new SCFile( "inccontacts" ); var rteReturn; // Access policy definition on file(contacts) and field(city) and datadict field defaults rteReturn = system.functions.policyread( incident_contacts_file, "file.contacts,city", "defaults" ); print( "DataPolicy on (joinfile:inccontacts, subfile:contacts, field:city), as defined in(file:datadict, field:defaults)" + rteReturn ); // Access policy definition on file(incidents) and field(phone) and datadict field defaults rteReturn = system.functions.policyread( incident_contacts_file, "file.incidents,phone", "defaults" ); print( "DataPolicy on (joinfile:inccontacts, subfile:incidents, field:phone), as defined in(file:datadict, field:defaults)" + rteReturn ); // Access policy definition on file(incidents) and field(phone), and datadata field readonly rteReturn = system.functions.policyread( incident_contacts_file, "file.incidents,phone", "readonly" ); print( "DataPolicy on (joinfile:inccontacts, subfile:incidents, field:phone), as defined in(file:datadict, field:readonly)" + rteReturn );
Example 3
function testPolicy() { var file = new SCFile( 'cm3r' ); var ret = system.functions.policyread(file, "assets", "reference.table" ); print( "The reference.table attribute for assets field in cm3r file is: ", ret ); ret = system.functions.policyread(file, "assets", "" ); print( "assets field in cm3r exists in data policy: ", ret ); ret = system.functions.policyread(file, "nofield", "" ); print( "nofield field in cm3r exists in data policy: ", ret ); ret = system.functions.policyread(file, "", "display.field" ); print( "display.field for file cm3r is: ", ret ); ret = system.functions.policyread("device", "", "display.field" ); print( "display.field for file device is: ", ret ); }
Example 3 returns the following results:
The reference.table attribute for assets field in cm3r file is: device
assets field in cm3r exists in data policy: true
nofield field in cm3r exists in data policy: false
display.field for file cm3r is: null
display.field for file device is: display.name