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