9 Eylül 2011 Cuma

Quick Reference

Command line

Run RAD application *a
Go to a menu *m

Application variables

ApplicationVariableDescription
Format control$filePrimary file record
Format control$filexA secondary query file where x is the an integer starting at 1
Format control$file0The primary file record before any modifications
Format control$script.nameThe script to run before accepting user input
Link$FilePrimary file record
Link$L.relatedThe file that is being created in an screlate link record
Link$L.primaryThe file that is the source when creating a related record in the screlate link record
Validity$valPrimary file record
Validity$vrfieldField being validated
Macro$L.newThe new file being saved
Macro$L.oldThe file before modifications
Display$L.filedThe current file record
Problem category$fileThe current problem ticket file record
Change phase$filerThe current request file record
Change phase$filer.oldThe before editing request file record
Change task$filetThe current task file record
Agent$L.resultsThe file record for the results of the query
Event Services$axcesThe file record for eventin
Event Services$axces.fieldsAn array of fields in an event map
Event Services$ax.query.passed
Event Services$axces.fieldThe value of the field being populated for the record being created
Event Services$axces.registerThe file record of the event register in use
Event Services$axces.targetThe file record for the record being created
Event Services$axcs.sourceThe 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 CodeExampleAction
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.
previousL.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.date
input.edate
input.fdate
input.number
input.percent
input.time

Output types

output.all.caps
output.asterisk
output.date
output.edate
output.exdate
output.fdate
output.fm
output.init.caps
output.money
output.no.caps
output.percent
output.privilege
output.time.adj
output.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

  1. mm/dd/yy
  2. dd/mm/yy
  3. yy/mm/dd
  4. mm/dd/yyyy
  5. dd/mm/yyyy
  6. 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.
andelsefornotstep
beginendifnullthen
dofalseinortrue
whileunknown



Link variables

Variable
Meaning
$File
The file variable for the associated record.
$fill.recurse
If true move to next entry after this one
$fill.skip
If true skip this entry
$fill.display
If true display the record before filling
$fill.option.skip
Skip the current link entry and move on when displaying the results of a recursive fill
$fill.display.add
Allows 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.replace
Determines if data is overwritten
$project.first
Project data before line by line
$fill.exact
Forces 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

Variabledbdict if file record type
$G.assignmentall assignment groups
$G.assignment.groupsall assignment groups
$G.assignment.plusall assignment groups plus %NONE%
$G.attrfilesattribute files
$G.auth.assignmentauthorized assignment groups
$G.auth.categoriesauthorized categories
$G.avail.printersavailable printers
$G.availability.mapsavailability maps
$G.calendarslist of calendars
$G.categoriesall problem categories
$G.categories.allall categories
$G.categorycategory
$G.cm.controlcmcontrol
$G.cm3r.environmentcm3profile
$G.cm3r.inboxesCM3R inboxes
$G.cm3r.mult.groups
$G.cm3t.environmentcm3profile
$G.cm3t.inboxesCM3T 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.displaymasterdisplaymaster
$G.euro.currency.codes
$G.files
$G.globals.setup
$G.groups
$G.icm.envicmenv
$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.environmentocmprofile
$G.ocml.inboxes
$G.ocmo.environmentocmprofile
$G.ocmo.inboxes
$G.ocmq.environmentocmprofile
$G.ocmq.inboxes
$G.old.print
$G.open.listsarray of global lists
$G.operator.plusall operators plus %NONE%
$G.operatorsall operators
$G.ph.expire.running
$G.pm.environmentpmenv
$G.pm.global.environmentenvironment
$G.pm.statusvalid pm status
$G.problem.inboxesproblem inboxes
$G.profileslist 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.environmentslacontrol
$G.sla.ids
$G.sla.inboxes
$G.sla.names
$G.sm.environmentsmenv
$G.sm.global.environmentenvironment
$G.sm.groups
$G.sm.profiles
$G.sql.db.types
$G.startup.lists
$G.sync.events
$G.technicians
$G.timezonetzfile
$lo.appl.nameapplication for operator
$lo.appl.namesparameter names
$lo.appl.valuesparameter values
$lo.cm.limit
$lo.company.namecompany name
$lo.copyright
$lo.date.orderdate format code
$lo.db.limit
$lo.db.time
$lo.deptdepartment
$lo.device
$lo.groups
$lo.homehome menu in gui
$lo.home.txthome 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

Hiç yorum yok:

Yorum Gönder