Ebase Xi Javascript – Quick Reference Card

Getting a field value

var val = fields.Requestor.value;

Setting a field value

fields.Department.value = "Finance";

fields.TodaysDate.value = new Date();

fields.time_now.value = new Date();

Adding a list to a field

var list = ["Line 1", "Line 2", "Line 3"];

fields.ListField.createCustomList(list);

Inserting a new row into a Table

tables.Order_Items.insertRow();

Setting a Table column value

tables.Order_Items.ItemAmount.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.OrderId = fields.Order.stringValue;

parms.CustomerId = fields.Customer.stringValue;

parms.CredirLimit = 9999;

form.callForm("OrderDisplay", parms);

Display a specific Page

form.gotoPage(pages.OrderPage);

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.Page1;
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();