Ebase Xi Javascript – Quick Reference Card

Getting a field value

var val = fields.REQUESTOR.value;

Setting a field value

fields.DEPARTMENT.value = "Finance";

fields.TODAYS_DATE.value = new Date();

fields.TIME_NOW.value = new Date();

Inserting a new row into a Table

tables.ORDER_ITEMS.insertRow();

Setting a Table column value

tables.ORDER_ITEMS.ITEM_AMOUNT.value = fields.AMOUNT.value;

Saving Table data to its backing resource

tables.ORDER_ITEMS.updateTable();

Loading a Table via its backing resource

var rows = tables.REQUESTS.fetchTable();

while ( rows.next() ) { .. }

Looping through table rows

var rows = tables.REQUESTS.rows;

while ( rows.next() )

{

fields.TOTAL.value += tables.REQUESTS.AMOUNT.value;

}

Sorting Table data

tables.REQUESTS.sort(tables.REQUESTS.DATE,

Table.SORT_DIRECTION_DESCENDING);

Working with Controls

controls.BUTTON1.backgroundColor = "Yellow";

controls.TEXT1.text.text = "Hello";

controls.PANEL5.hide();

Calling a Form

var parms = {};

parms.ORDER_ID = fields.ORDER.stringValue;

parms.CUSTOMER_ID = fields.CUSTOMER.stringValue;

parms.CREDIT_LIMIT = 9999;

form.callForm("ORDER_DISPLAY", parms);

Display a specific Page

form.gotoPage(pages.ORDER_PAGE);

Working with Resources

resources.REQUESTS.update();

resources.EMAIL1.sendmail();

resources.HR_GET_EMPLOYEE_DETAILS_WS.call();

Incrementing a Sequence

var next = system.sequenceManager.sequence("SEQ1");

Issuing Messages

controls.FIELDCONTROL1.addWarningMessage("This is a warning message..");

event.owner.addErrorMessage("Your input is invalid..");

// multiple error messages

event.owner.addErrorMessage("Message 1..", false);

event.owner.addErrorMessage("Message 2.." , false);

event.owner.addErrorMessage("Message 3.." , false);

event.stopExecution();

File Services

FileServices.createNewFile("C:/files/myfile.txt");

FileServices.copyFile("C:/files/myfile.txt",

"C:/more_files/myfile.txt");

FileServices.deleteFile("C:/files/myfile.txt");

Security Services – logging on and off

system.securityManager.logon(

[ ["Script", fields.USER.value],

["Script", fields.PASSWORD.value] ] );

system.securityManager.logoff();

Working with modifiers

var page = pages.PAGE_1;
for each (var ctrl in page.getControlsByModifier("Audit"))
{
   if (!system.securityManager.hasRole("FINANCE_CONTROLLER"))
   {
 ctrl.hide();
   }
 }
 

Handing Exceptions

try
{
system.securityManager.logon([ ["Script", fields.USER.value], 
 ["Script", fields.PASSWORD.value] ]);
}
catch (e)
{
  event.owner.addErrorMessage(e);  
  log (e);
}

Accessing Java classes

var date = new java.util.Date();

var d1 = date.getTime();

var cal = java.util.Calendar.getInstance();

var d2 = cal.getFirstDayOfWeek();