29 Mayıs 2011 Pazar

Expertise Contest Project #3 >> MySM HTML-Based Dashboard

Başlama Tarihi: 01/06/2011
Bitiş Tarihi: 25/06/2011
Başlık : MySM HTML-Based Dashboard
Seviye: İleri
Açıklama: 


5 Mayıs 2011 Perşembe

rtecall vs JavaScript

>x $L.void=rtecall("rinit", $L.rc, $my.contacts, "contacts")
true
>d $my.contacts
contacts={[, , , , , , , , , , , , , , , {}, {}, {}, , , , , , , , , , , , , {}, , , , , , , , , , , , , , , , , , , , , , , , , {{[, ]}}, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , {}, {}, , , , , , , , , ]}
>x $L.void=rtecall("select", $L.rc, $my.contacts, "contact.name=\"AEVA ADMIN\"")
true
>d $my.contacts
contacts={["ADMIN", "admin", , , "DIVISION", "ALI", "SMITH", , , , , "xx@xyz.com", , , , {}, {}, {}, , "ENGINEER", , , , , , , , , "AA_AEVA", , {}, , , , "falcon", false, '16/09/10 16:43:51', , 1, , , , , 9, "falcon", , , , , , , , , , , {{[, ]}}, , , , , , , , , "admin", , , , , , , , "FT", , , , , , , , , "AA_AEVA", , "DIVISION", , , "AEVA ADMIN", , "DIVISION", "DEPARTMENT", "DIRECTORATE", "GROUP", {"TESTPM"}, {}, , , , , , , , , ]}

var fContact = new SCFile("contacts")
print(fContact);>>
[C++ object SCFile] - contacts={[, , , , , , , , , , , , , , , {}, {}, {}, , , , , , , , , , , , , {}, , , , , , , , , , , , , , , , , , , , , , , , , {{[, ]}},
 , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , {}, {}, , , , , , , , , ]}
fContact.doSelect("contact.name=\""+"AEVA ADMIN"+"\"");   
print(fContact); >>
[C++ object SCFile] - contacts={["ADMIN", "admin", , , "DIVISION", "ALI", "SMITH", , , , , "xx@xyz.com", , , , {}, {}, {}, , "ENGINEER", , , , , , , , , "AA_AEVA", , {}, , , , "falcon", false, '16/09/10 16:43:51', , 1, , , , , 9, "falcon", , , , , , , , , , , {{[, ]}}, , , , , , , ,
, "admin", , , , , , , , "FT", , , , , , , , , "AA_AEVA", , "DIVISION", , , "AEVA ADMIN", , "DIVISION", "DEPARTMENT", "DIRECTORATE", "TECHNOLOGY", {"TESTPM"}, {}, , , , , , , , , ]}

Index of rtecalls

•    rtecall("alalnum")
Checks to make sure a string contains only alphanumeric characters, or only alphanumeric characters and the provided non-alphanumeric characters
•    rtecall("alnum")
Checks to make sure a string contains only numeric characters, or only numeric characters and the provided non-numeric characters
•    rtecall("alpha")
Checks to make sure a string contains only alphabetic characters, or only alphabetic characters and the provided non-alphabetic characters
•    rtecall("counter")
Turns counters on or off for the current session. Other SC users are unaffected
•    rtecall("datemake")
Returns a date, in the proper form, based upon a series of numbers passed to it
•    rtecall("escstr")
Precedes special characters in a string with an escape character
•    rtecall("FILLDATE")
Places the current date and time in a field in the current record
•    rtecall("filecopy")
Copies all of the data in a collection to another file variable
•    rtecall("fileinit")
Initializes a new file (rinit) in $targetfile
•    rtecall("getnumber")
Replaces the getnumb RAD application
•    rtecall("getrecord")
Retrieves the record identified by unique key values in $L.array
•    rtecall("getunique")
Returns into $L.array the values for the unique key from the current record in $L.file
•    rtecall("log")
Sends a message to the external sc.log file
•    rtecall("notypecheck")
Turns type checking off or on
•    rtecall("passchange")
Changes this user's password
•    rtecall("policycheck")
Imposes data policy as defined in the datadict table
•    rtecall("qbeform")
Returns a QBE form, which can be passed into an rio or fdisp panel
•    rtecall("radd")
Adds a record
•    rtecall("radhistory")
Keeps track of the RAD panels a user has executed when running ServiceCenter applications
•    rtecall("recdupl")
Copies the contents of the current record into the contents of another record
•    rtecall("rfirst")
Places the pointer at the first record in a record collection (a QBE list)
•    rtecall("rgoto")
Places the pointer at the indicated record.id in a record collection (a QBE list)
•    rtecall("rid")
Returns the record number of the current record (represented by $L.file)
•    rtecall("rinit")
Initializes a new file
•    rtecall("rupdate")
Update a record
•    rtecall("select")
Searches for records
•    rtecall("sort")
Sorts a list or a list of lists in ascending or descending order
•    rtecall("transtart")
Measures the amount of data transferred, elapsed time and CPU usage of any transaction
•    rtecall("transtop")
Measures the amount of data transferred, elapsed time and CPU usage of any transaction. It is commonly invoked from the GUI debugger and is used in conjunction with transtart
•    rtecall("trigger")
Turns triggers on or off for the current session

2 Mart 2011 Çarşamba

Link Control Variables

$fill.replace  (Default=true)
If false, Service Manager does not replace fields that already contain data.
$fill.exact  (Default=false)
If true, Service Manager only copies to fields with the same name and type at the same level within the database dictionary.
$fill.display   (Default=false)
If true, displays the target record before copying data into the source record.
$project.first  (Default=false)
If true, Service Manager projects data between like-named fields before copying unlike-named fields defined in the link record’s Fill From/Fill To list.
$fill.recurse  (Default=false)
If true, the next line in the link record is automatically executed.
$fill.skip  (Default=false)
If true, skips the current entry and continues
processing based on the value of
$fill.recurse for that entry.
$fill.option.skip  (Default=false)
If true, the option to skip the current link becomes available.
$fill.search.format="contacts.search.g"
NOTE:
$fill.display must equal true for $fill.option.skip to function.

Common File Variables

Common File Variables

$L.file           Data Policy (also used in Notifications and the Document Engine)
                    Format Control
$file,             primary file record
$file0,           primary file record before any modification
$filex            secondary query file where x =integer starting at 1
$File             Links
$L.filed         Display: screen, option, event
$L.file.save   Notifications: the old version of the record in play when the   notification is triggered.
$L.new         Macros: changed record (triggers too)
$L.old           Macros: original record (triggers too)
$script          Scripts

record, 
oldrecord      Triggers

8 Şubat 2011 Salı

ServiceManager Expertise Contest Project #2 >> System Health Monitor

Başlama Tarihi: 14/08/2011
Bitiş Tarihi: 25/18/2011
Başlık : System Health Monitor / Sistem Sağlığı İzleme
Seviye: İleri
Açıklama: 

Belli tablolardaki günlük kayıt sayısının aşırı bir şekilde artması, belli background proseslerin idle kalması veya kapanması, belli kullanıcıların izlenmesi(mesela entegrasyonda kullanılanın lockout olması), locklanmış kayıtların ne kadar lock'lı kaldığının izlenmesi gibi.....