Command line
Run RAD application *a
Go to a menu *m
Application variables
| Application | Variable | Description |
| Format control | $file | Primary file record |
| Format control | $filex | A secondary query file where x is the an integer starting at 1 |
| Format control | $file0 | The primary file record before any modifications |
| Format control | $script.name | The script to run before accepting user input |
| Link | $File | Primary file record |
| Link | $L.related | The file that is being created in an screlate link record |
| Link | $L.primary | The file that is the source when creating a related record in the screlate link record |
| Validity | $val | Primary file record |
| Validity | $vrfield | Field being validated |
| Macro | $L.new | The new file being saved |
| Macro | $L.old | The file before modifications |
| Display | $L.filed | The current file record |
| Problem category | $file | The current problem ticket file record |
| Change phase | $filer | The current request file record |
| Change phase | $filer.old | The before editing request file record |
| Change task | $filet | The current task file record |
| Agent | $L.results | The file record for the results of the query |
| Event Services | $axces | The file record for eventin |
| Event Services | $axces.fields | An array of fields in an event map |
| Event Services | $ax.query.passed | |
| Event Services | $axces.field | The value of the field being populated for the record being created |
| Event Services | $axces.register | The file record of the event register in use |
| Event Services | $axces.target | The file record for the record being created |
| Event Services | $axcs.source | The file record for the map |
Functions
cursor.field.contents()
cleanup(<variable>)
date(<variable>)
day(<variable>)
dayofweek(<variable>)
dayofyear(<variable>)
delete(<array>,<start>,<number>)
denull(<variable>)
$junk=fduplicate(<into file>, <from file>)
filename(<variable>)
filesize(<variable>)
genout(<file variable>, <format name>)
get.dateformat()
get.timezoneoffset()
gui()
index(<string>, <search in>)
insert(<array>,<position>,<count>,<string>)
lng(<variable>)
month(<variable>)
null(<variable>)
nullsub(<first choice>, <second choice>)
operator()
option()
$junk=recordcopy(<from file>, <from fields>, (<to file>, <to fields>,
same(<variable>, <variable>)
set.timezone()
str(<variable>)
$junk=stradj(<string>,<number>)
$junk=strclpl(<string>,<number>)
$junk=strclpr(<string>,<number>)
substr(<string>, <start>, <length>)
time(<variable>)
tod()
tolower(<variable>)
toupper(<variable>)
translate(<variable>, <old chars>, <new chars>)
type(<variable>)
val(<variable>, <type>) 1 num, 2 str, 3 d/t, 4 log
year(<variable>)
RTE calls
$L.rc is the return code.
| RTE Code | Example | Action |
| alalnum | $L.test=rtecall("alalnum”, $L.rc, $L.string, $L.special) | Checks to see if $L.string contains only alphanumeric characters. Evaluates to true or false. $L.special holds special characters that are also okay to have. |
| alnum | $L.test=rtecall("alnum”, $L.rc, $L.string, $L.special) | Checks to see if $L.string contains only numeric characters. Evaluates to true or false. $L.special holds special characters that are also okay to have. |
| alpha | $L.test=rtecall("alpha", $L.rc, $L.string) | Checks to see if $L.string contains only alphabetic characters. Evaluates to true or false. $L.special holds special characters that are also okay to have. |
| counter | $L.test=rtecall("counter", $L.rc, 0) | Turns counters on with 1 and off with 0. |
| getnumber | $L.test=rtecall(“getnumber”, $L.rc, $L.number, $L.class, $L.field) | Gets the next number and puts it into $L.number using the class in $L.class. $L.field is not used. |
| log | $L.test=rtecall("log", $L.rc, $L.message) | This sends a message to sc.log. |
| msg | $L.test=rtecall("msg", $L.rc,$L.message, $L.level) | This sends a message to the screen. $L.level is 1, 2, or 3. |
| next | $L.test=rtecall("next", $L.rc, $L.file)) | Moves pointer for $L.file to next record. |
| previous | L.flg=rtecall("previous", $L.rc, $L.file) | Moves the pointer for $L.file to the previous record. |
| radd | $L.test=rtecall("radd", $L.rc, $L.file) | Adds the record $L.file. |
| rdelete | $L.test=rtecall("rdelete", $L.rc, $L.file) | Deletes the record $L.file. |
| rfirst | $L.test=rtecall("rfirst", $L.rc, $L.file) | Moves the pointer for $L.file to the first record in the qbe. |
| rgoto | $L.test=rtecall("rgoto", $L.rc, $L.file, $L.record.number) | Moves the pointer for $L.file to $L.record.number. |
| rid | $L.test=rtecall("rid", $L.rc, $L.file, $L.record.number) | Sets $L.record.number to the number of the current record pointed to by $L.file. |
| rinit | $L.flg=rtecall("rinit", $L.rc, $L.file, "filename") | Initializes the variable $L.file to the dbdict found in position 4. |
| rupdate | $L.flg=rtecall("rupdate", $L.rc, $L.file) | Updates the record for $L.file. |
| select | $L.flg=rtecall("select", $L.rc, $L.file, $L.qry) | Issues a select against $L.file using the query in position 4. |
| sort | $L.void=rtecall("sort", $L.rc, $L.grid, $L.index, 0)) | Sorts the array of arrays in $L.grid using the array $L.index |
| trigger | $L.void=rtecall("trigger", $L.rc, 0) | Turns triggers on with 1 and off with 0 |
Input/Output applications for forms designer
Input types
- input.dateinput.edateinput.fdateinput.numberinput.percentinput.time
Output types
- output.all.capsoutput.asteriskoutput.dateoutput.edateoutput.exdateoutput.fdateoutput.fmoutput.init.capsoutput.moneyoutput.no.capsoutput.percentoutput.privilegeoutput.time.adjoutput.yn
Masks for dates:
mmm dd, yyyy Mar 31, 1999
dd mmm, yyyy 31 Mar, 1999
dd xxx, yyyy 31 March, 1999
xxx dd, yyyy March 31, 1999
jjj yyyy 90 (Julian date)
yyyy jjj 1999 90 (Julian date)
mm/dd/yyyy 03/31/1999
dd/mm/yyyy 31/03/1999
yyyy/mm/dd 1999/03/31
mm-dd-yyyy 03-31-1999
dd-mm-yyyy 31-03-1999
yyyy-mm-dd 1999-03-31
mm.dd.yyyy 03.31.1999
dd.mm.yyyy 31.03.1999
yyyy.mm.dd 1999.03.31
Color schemes
blues dkblues rose marine purple
purples dkgreens rainyday plum greens
browns eggplant maple tranquil slate
lilac desert
Subroutines for format control, menu, scripts
apm.global.initer
name create means to create the global
names <lists> array of list names
bu.record.add
record <$file> record to be added
boolean1 <t/f> true is no message
name <message> the add message
bu.record.delete
record <$file> record to be deleted
boolean1 <t/f> true is no message
name <message> the delete message
bu.record.update
record <$file> record to be updated
boolean1 <t/f> true is no message
name <message> the update message
getnumb.fc
record <file> file variable
name <class> number class
prompt <field> field to get the number
macro.mail1
name <address> raw email address
query <operator> an operator name
contact <contact> a contact.name value
names <message> message in an array
string1 <subject>
macro.mailmany
name <addresses)> array of raw email addresses
query <operators)> array of operator names
contact <contacts)> array or contact.name values
names <message> message in an array
string1 <subject>
macro.page1
name <telephone> pager phone
query <operator> operator
string1 <msg type> message type
text <message> message text
prompt <contact> contact
macro.page.many
name <telephone> pager phone
query <operator> operator
string1 <msg type> message type
text <message> message text
prompt <contact> contact
query.array
name <field name> field name to query on
text <array> values to put in the query
prompt <query> passed back
string1 <and/or> the separator
query <field type> number, character, date/time,
script.execute
name <script> name of the script
us.sort.array
sort <array> array to be sorted
us.cleanup.array
names <array> sort and denull the array
us.delete
name <file name> name of the file
query <query> query for files to delete
us.launch.external
name <program> program to launch
us.sort.as
names <array/structure> array to sort
index <number> element to sort on
boolean1 <t/f> true for descending sort
us.link
record <file>
name <field>
prompt <action> fill or find
validate.fields
second.file $file file record to validate
name <field> use if single field
names <list of fields> use if multiple fields
Data types
1 number 2 character
3 date/time 4 logical
6 record 8 array
9 structure 11 expression
Date format codes
- mm/dd/yy
- dd/mm/yy
- yy/mm/dd
- mm/dd/yyyy
- dd/mm/yyyy
- yyyy/mm/dd
Reserved words
The following words are reserved in ServiceCenter and cannot be used as variable or field names. However, they can be used as parts of variable or field names.
and else for not step begin end if null then do false in or true while unknown
Link variables
- VariableMeaning$FileThe file variable for the associated record.$fill.recurseIf true move to next entry after this one$fill.skipIf true skip this entry$fill.displayIf true display the record before filling$fill.option.skipSkip the current link entry and move on when displaying the results of a recursive fill$fill.display.addAllows you to add a record if none found$fill.structure$fill.structure={1, “structure”} 1 is the source field and structure is the name$fill.replaceDetermines if data is overwritten$project.firstProject data before line by line$fill.exactForces to obey data types and indexes
Useful queries
Find a string anywhere in a field:
index(<string>, <field name>)>0
Note: do not use “in $file”
Find a string anywhere in a record:
index(<string>, str(contents(currec()))>0
Find records using a list:
<field name> isin <array>
Global variables
Variable dbdict if file record type $G.assignment all assignment groups $G.assignment.groups all assignment groups $G.assignment.plus all assignment groups plus %NONE% $G.attrfiles attribute files $G.auth.assignment authorized assignment groups $G.auth.categories authorized categories $G.avail.printers available printers $G.availability.maps availability maps $G.calendars list of calendars $G.categories all problem categories $G.categories.all all categories $G.category category $G.cm.control cmcontrol $G.cm3r.environment cm3profile $G.cm3r.inboxes CM3R inboxes $G.cm3r.mult.groups
$G.cm3t.environment cm3profile $G.cm3t.inboxes CM3T inboxes $G.cm3t.mult.groups
$G.contract.ids
$G.contract.names
$G.currency.codes
$G.currency.names
$G.departments
$G.devbitmaps
$G.device.inboxes
$G.devnames
$G.devnames.all
$G.devtypes
$G.devtypes.all
$G.displaymaster displaymaster $G.euro.currency.codes
$G.files
$G.globals.setup
$G.groups
$G.icm.env icmenv $G.icm.initialized
$G.icm.status
$G.inbox.types
$G.incident.inboxes
$G.itil
$G.joinfiles
$G.language.all.ids
$G.language.all.names
$G.language.ids
$G.language.names
$G.location.names
$G.locations
$G.max.attach.size
$G.my.currency
$G.my.language
$G.ocml.environment ocmprofile $G.ocml.inboxes
$G.ocmo.environment ocmprofile $G.ocmo.inboxes
$G.ocmq.environment ocmprofile $G.ocmq.inboxes
$G.old.print
$G.open.lists array of global lists $G.operator.plus all operators plus %NONE% $G.operators all operators $G.ph.expire.running
$G.pm.environment pmenv $G.pm.global.environment environment $G.pm.status valid pm status $G.problem.inboxes problem inboxes $G.profiles list of all problem profiles $G.prompt.for.save
$G.rfc.fields
$G.rfc.names
$G.rfc.reasons
$G.rfc.reasons.desc
$G.root.currency
$G.sch.events
$G.service.groups
$G.sla.environment slacontrol $G.sla.ids
$G.sla.inboxes
$G.sla.names
$G.sm.environment smenv $G.sm.global.environment environment $G.sm.groups
$G.sm.profiles
$G.sql.db.types
$G.startup.lists
$G.sync.events
$G.technicians
$G.timezone tzfile $lo.appl.name application for operator $lo.appl.names parameter names $lo.appl.values parameter values $lo.cm.limit
$lo.company.name company name $lo.copyright
$lo.date.order date format code $lo.db.limit
$lo.db.time
$lo.dept department $lo.device
$lo.groups
$lo.home home menu in gui $lo.home.txt home menu in text $lo.i
$lo.language
$lo.main
$lo.month.abv
$lo.month.ext
$lo.msglog.lvl
$lo.pm.limit
$lo.system.startup
$lo.time.zone
$lo.uallow.syslog
$lo.uallow.timezone
$lo.uapprovals
$lo.ucapex
$lo.uchgmgr
$lo.uchgrps
$lo.ucm.print
$lo.ufname
$lo.ulogin.time
$lo.ulogoff.parm
$lo.upm.print
$lo.user.name
dbdicts
agent
application
applicationfields
assignment
audit
auditspecs
availability
availabilitymap
bulletin
caldaily
caldutyhours
calholidays
capability
category
clocks
cm3eventack
cm3groups
cm3messages
cm3profile
cm3profilegrp
cm3r
cm3ralerts
cm3rcategory
cm3rcatphase
cm3rpage
cm3t
cm3talerts
cm3tcategory
cm3tcatphase
cm3tpage
cmcontrol
cmlabor
cmparts
code
company
config
contacts
core
counters
datadict
datadump
datamap
dateformat
datetest
dbdict
dbfield
dbkey
ddescript
devaudit
devauditcontrol
device
devtype
displaycache
displayevent
displaymaster
displayoption
displayscreen
distgroup
downtime
dtqueue
dtshad
enclapplication
enclapplrev
enduser
environment
erddef
errmsg
errorlog
escommand
eventfilter
eventin
eventmap
eventout
eventregister
export
field
format
formatctrl
globallists
goeconfig
group
help
helptext
icmdecide
icmenv
import
inbox
incdepends
incidents
info
interface
irfields
irqueue
joindefs
keys
keyword
knowledge
KnowledgePak
language
languagecodes
macro
macrodef
macroheader
mail
mapappl
marquee
menu
menucmdlist
model
modelconfig
modelvendor
msgclass
msgjcl
msglog
msgtext
number
ocmalertlog
ocmalertpool
ocmapprlog
ocmapprpool
ocmcatselect
ocmcowork
ocmevents
ocmgroups
ocml
ocmlcat
ocmlpage
ocmlrec
ocmlwork
ocmo
ocmocat
ocmopage
ocmoptions
ocmphaselog
ocmprofile
ocmq
ocmqcat
ocmqpage
operator
operaudit
outage
outagedetail
pageinfo
patches
pmenv
pmnotes
pmstatus
pmtapi
port
printer
probcause
problem
probsummary
protocore
querystored
remotecontrol
report
reportquery
resolution
scaccess
scautotest
scdsites
SCEmail
schedule
scldapconfig
scmandant
scmessage
screlation
screlconfig
scripts
scsearchstep
scsecuritygroup
sctypecheck
scversion
server
service
servicecontract
serviceent
sessionlog
shutdown
signaturemake
signatures
sla
slaactive
slaassign
slacontrol
slamonthly
slamonthlyag
slaresponse
smenv
software
software1
solution
spool
spoolheader
sqldbinfo
sqlhints
sqloptions
sqlqueue
sqlsystemtables
sqltransactionlog
sqlupgrade
sqlwords
state
stathistory
status
subcategory
submission
subtotals
subtype
switch
SYSBLOB
syslog
SystemEvents
systemmonitor
taxcodes
techterms
telecom
termtype
textfields
tpdevice
transactioncount
triggers
typecheck
tzfile
unload
upgdbdict
upgenclapplication
upgrade
validity
vendor
work
