User Tools

Site Tools


Tree Objects

The Tree is a hierarchy of objects available in the EASAP Builder.

The Child objects one level below 'EASAP' are called branches, objects two levels below are called sub-branches.

  • The EASA Help Pages use two different notions for Parent-Child object relationships,
    1. A right arrow to show Parent - Child relationships horizontally,
      • parent_object → child_object
    2. Indented space in a vertical outline format similar to expanded Tree objects in the Builder,
      • parent_object
        • child_object

PROPERTIES branch

PROPERTIES branch
APPLICATIONadministrative properties of the EASAP such as 'Name'
CATEGORYdefine which Users will have access to which EASAP's

SPREADSHEET LIST branch

SPREADSHEET LIST branch
SPREADSHEETspecify the name of the Excel workbook.
SHEETidentify a specific worksheet within the Excel workbook
RANGE REFERENCEreference to individual cell(s) within the worksheet
FORMULA REFERENCEreference to a formula object within the worksheet
CHART REFERENCEreference to a chart object within the worksheet
NAMED RANGE LISTa Parent to all NAMED RANGE's
NAMED RANGEcreated automatically by the Excel Range Wizard

USER INTERFACE branch

USER INTERFACE Parent to all GUI objects

USER INTERFACE STYLE LIST

USER INTERFACE STYLE LIST sub-branch
USER INTERFACE STYLESParent for USER INTERFACE STYLE objects
USER INTERFACE STYLEParent to style attributes → MARGIN, BORDER, PADDING
BACKGROUNDdefine the style of an object's background
BORDERdefine an object's border
TEXT STYLEdefine the text attributes for an HTML style
MARGINdefine the space outside of a border
PADDINGdefine the space between an object and its border
OTHER STYLEdefine other CSS properties using standard syntax

FORM LIST or TABBED PANE LIST

FORM LIST or TABBED PANE LIST sub-branches
FORM

TABBED PANE
Parent for GUI objects on a popup window when an OPEN FORM ACTION is executed

Parent for GUI Objects in an EASAP's user interface
BUTTONrectangular region that triggers an ACTION when clicked
CASE VIEWERtable for the selection of a case and subsequent launch of an Excel Client
EXTERNAL FILTERapply SQL query to filter the case records visible in a CASE VIEWER
FILTERlogical comparison to filter the case records visible in a CASE VIEWER
CHOICE LISTselect an input value from a drop down list of possible values
DATEBOXinput and format a date
ESIGNER provide a digital validation of “data integrity at a certain time by an authorized party” in an EASAP interface.
STAGE OPTIONSdefine restrictions involving a group of Users and an EASAP stage on who is allowed to validate an EASAP's data
ESIGNER VIEWER display the current certification status and history of the EASAP
FILE CHOICEselect a file from local file system for use by an EASAP
IMAGEdisplay an image in the GUI
INPUTBOXversatile data entry component that can be configured to behave in a variety of modes
CONDITIONAL FORMATTINGchange the appearance of an INPUTBOX if a certain condition applies
DATA VALIDATIONdefine what data is allowed to be entered by a User
PARAMETRIC RANGEperform a parametric study varying inputs over a range
INTEGERBOXaccept integer input
LABELdisplay text and image data
 LAYOUT PANEL precisely control the layout and CSS style of GUI objects
LOGICBOXaccept either 'checked' or 'unchecked' selection as input
REALBOXaccept a real or decimal number as input
SPACERvertical or horizontal space between adjacent objects on the Tree
SUB PANEcontainer for GUI objects arranged in a box
TABBED PANE LISTcontainer for TABBED PANE's
TABULATED DATAdisplay tables of LIST data
TEXTAREAaccept input text and displays output text
TEXTBOXaccept input text in a box
TABBED PANE (only)
Parent for GUI Objects in an EASAP's user interface
DATA PROCESSINGParent object for DATA PROCESSING tools
DATA TABLEallow an array of INPUTBOX's and LOGICBOX's for User input
HEADER allow GUI objects to be displayed above each column
SPACERallow space between columns
INPUTBOX LISTcreate a column of INPUTBOX's
LOGICBOX LISTcreate a column of LOGICBOX's
 EVENT PROCESSINGParent for EVENT PROCESSING tools below
SLIDERaccept a mouse-selected numerical value within a specified range as input
POLLprovide the ability to automatically, repeatedly trigger an action at a defined interval.

DIAGRAM LIST

DIAGRAM LIST sub-branch
2D GRAPHcreate plots from data stored within LIST's
CONTOUR DATAspecify contour data to be plotted
LEGENDadd a visibile legend to a graph
LINE DATAspecify line data to be plotted
TITLEspecify the main and sub titles
X AXISspecify properties of the horizontal axis
Y AXISspecify properties of the vertical axis
DIAGRAMParent for 2D diagram component objects
ARROWan arrow with dynamic coordinates
CURVEcreate different types of curves through a series of plot points
DATA PROCESSINGParent object for DATA PROCESSING tools
DIMENSIONproduce a special set of lines for illustrating a dimension
IMAGEdisplay image files in the input region of a TABBED PANE
LINEa series of connected line segments
OVALcreate ellipses and circles
POLYGONproduce polygons on a DIAGRAM
RECTANGLEdefine a rectangle
SECTORmake a sector of a circle (ie. ‘a pie slice’)
TEXTannotate a diagram with text
STYLE LISTParent of STYLE objects
FILL STYLEdefine a coloring scheme to fill an enclosed object.
LINE STYLEdefine a particular style of line for use in other DIAGRAM's
TRANSFORMperform a repeated or complicated transformation of a DIAGRAM's orientation

UNIT MANAGER

UNIT MANAGER sub-branch
BASE UNITSdefine the system of units to be used for the five base dimensions → Mass, Length, Time, Angle, and Temperature
DEFAULT UNITSa list of pre-existing sets of units
USER UNITSdefine new sets of units not found under DEFAULT UNITS
DIMENSIONAL GROUPrepresent a specific type of measurement derived from the BASE UNITS
CONVERSIONcreate additional units beyond the base units

PROCESSES branch

PROCESSES branch
CLEAR EXCEL RANGEclear values in cells or NAMED RANGES
CUSTOM PROCESS ACTIONexecute custom written Java code
DATA PROCESSINGParent for DATA PROCESSING tools
DATA PROCESSING ACTIONSParent object for other ACTION's
DATEallow the current date and/or time to be stored in an explicit SCALAR
EXTRACTextract data from a file
SET LISTset an explicit LIST
SET SCALARset an explicit SCALAR
DATABASE ACTIONperform a one time action on a DATABASE
DATABASEdefine the database on which to perform the action
 CLOSE CONNECTIONafter a READ/WRITE sequence
close the database connection
READexecute a SELECT statement in SQL
WRITEexecute an INSERT, UPDATE or DELETE 
EMAILsend an email message to Users
EXCEL ACTION GROUP Parent to an abitrary sequence of Excel-related ACTION's.
EXPORT TO PDFcreate a snapshot of a specified spreadsheet range as a PDF document and saves it on the file system
FILE MANAGEMENTminimize disk usage in EASA
IMAGE EXCEL ACTIONextract a screen capture of cell range or chart in an Excel spreadsheet for display by an IMAGE in a DIAGRAM
PROCESSrun an underlying software application
CLEAR FILESPACEminimize the disk space used by files generated from an EASAP run
DATA PROCESSINGParent object for DATA PROCESSING tools
FAILED IFdefine conditions for which the EASAP run is deemed to have failed
MONITORmonitor the progress of a process currently submitted to the EASAP queue
REPLACEMENTsearch a file for all delimited object references and replaces them with the appropriate object values
READ EXCEL ACTIONread values from specified cell ranges in Excel spreadsheets into specified LIST's
RUN MACRO ACTIONexecute a macro in an Excel spreadsheet
STOPdefine a complete mechanism for stopping the EASAP
STOP PROCESSdefine a method to stop a PROCESS
WRITE EXCEL ACTIONwrite values from one or more LIST's into specified cell ranges in Excel spreadsheets.

OUTPUT branch

OUTPUT branch
DATA PROCESSINGParent object for DATA PROCESSING tools
HTML STYLE LISTParent object for DEFAULT HTML STYLES and CUSTOM HTML STYLES
CUSTOM HTML STYLESParent object for additional styling objects
HTML STYLEParent to styling objects
BACKGROUNDdefine the style of an object's background
BORDERdefine an object's border
TEXT STYLEdefine the text attributes for an HTML style
MARGINdefine the space outside of the border of the object being formatted
PADDINGdefine the space between the object being formatted and its border
OTHER STYLEdefine other Custom Style Sheet (CSS) properties using standard CSS syntax
TABLE STYLEspecify an HTML STYLE to apply to various parts of a TABULATED DATA
DEFAULT HTML STYLEScollection of existing style objects
NOTESspecify the text message that will be displayed under
EASA→User→Results→My Results
PARAMETRIC REPORTParent object for multi-run parametric output
PARAMETRIC TABLEcreate a table with results from multiple runs
REPORTParent object for report content elements
2D GRAPHcreate plots from LIST data
CONTOUR DATAspecify contour data to be plotted
LEGENDactivate a legend on a graph
LINE DATAspecify line data to be plotted
TITLEspecify the main and sub titles
X AXISspecify the properties of the horizontal axis
Y AXISspecify the properties of the vertical axis
CASE VIEWERtable showing cases from the EDC database
EXTERNAL FILTERapply SQL query to filter the records visible in a CASE VIEWER
FILTERlogical comparison to filter the records visible in a CASE VIEWER
ESIGNER VIEWER display the current certification status and history of the EASAP
HTML OUTPUTrapidly create impressive looking reports within EASA
LAYOUTarrange report objects into a tabular layout, Child objects common to REPORT
RESULTS TABLEcreate a two-column-wide table with titles in the first column and report content in the second column
DATAdisplay data within the rows of a RESULTS TABLE
PLOTdisplay an image file and a plot title in a report
TABULATED DATAcreate a table of list data
TEXT OUTPUTcreate a basic text element

DATA PROCESSING

SCALAR

SCALAR DATA PROCESSING
COMPUTEstore a value of an expression containing a SCALAR
CONTACT DETAILSreturn user name, full name or e-mail address of user
CUSTOM SCALARreturn SCALAR generated using custom Java code within the EASA API
DATE COMPARISONcompare two date SCALAR's against each other
DATE CONVERSIONconvert date SCALAR's from one format to another
EXPANDcreate a single instance of one or more lines of text
FILE SYSTEMdetermine existence of a file or returns its full path or URL
SCALAR DOR VALUEstore a SCALAR, typically for use with a CUSTOM ACTION
FORMATperform formatting on a numerical SCALAR DOR
GET INDEXretrieve an index from a LIST given a value to find in the LIST
GET VALUEretrieve a value from a LIST given a location or index within the LIST
IS VALIDdetermine if another object value is valid
MAPmapping from a LIST (Inputs:) to a new value specified in another LIST (Outputs:)
REPLACEreplace part of a string of text
SEARCHfind the location of text within a string of text
STATISTICScompute a statistic: average, count, maximum, minimum, first, last, standard deviation, sum
STRINGtext operation on a string (eg. converts to upper case)
SUBSTRINGextract part of a string of text based on start and end character positions
SYSTEM PROPERTYgenerate a SCALAR from a Java system property

LIST

LIST DATA PROCESSING
AUTO LISTgenerate a LIST of numbers or letters given a list size
CONCATENATEconcatenate LIST's and/or SCALAR's together into one LIST
CUMULATIVE SUMcompute a LIST by cumulatively summing the values of another LIST
CUSTOM LISTreturn LIST of values generated using custom Java code within the EASA API
CUSTOM MULTI-LISTreturn a LIST of new LIST names generated using custom Java code within the EASA API
CUTcut out a subset of values from an existing LIST
DATABASEa READ will retrieve list data from a database
LIST DOR VALUEstore a LIST of values, typically for use with CUSTOM ACTION's
EXTRACTREPEAT and FIND extract LIST data from a file
INTERLEAVEcombine existing lists to produce one interleaved LIST
JSONPATHaccept a JSON string and query and returns data
MAPPED LISTselect a LIST based on a SCALAR input value
OBJECT QUERYretrieve name, value and parameter value information from other objects
REPEATED COMPUTEstores repeated values of an expression based on a given LIST
REPEATED DATE CONVERSIONconvert a LIST of dates from one date format to another
REPEATED EXPANDcreate a LIST containing one or more lines of text for each value of a given LIST
REPEATED FORMATformat a LIST DOR of numerical values
REPEATED GET INDEXretrieve indexes from a LIST given the values to find in the LIST
REPEATED GET VALUEretrieve values from a LIST given locations or indexes within the LIST
REPEATED MAPsame as SCALAR MAP except each value of a LIST is mapped
REPEATED REPLACEreplace text within a string, repeated for each string in LIST.
REPEATED SEARCHfind the location of text within a string, repeated for each string in a LIST
REPEATED STRINGText operation on a string (eg. converts to upper case), repeated for each string in LIST.
REPEATED SUBSTRINGextract part of a string based on start and end character positions, repeated for each string in LIST
SETperform set operations such as intersection on a pair of LIST's
SORTproduce a LIST containing the values of another LIST sorted alphanumerically based on its own or yet another LIST's values
SPLITsplit a text string into a LIST given a separator found in the text string
UNIQUE LIST DORreduce a LIST of elements into a set of unique elements.
XPATHextract data from XML using XPath

EVENT PROCESSING

EVENT

EVENT's
APPLICATION OPENEDrecognize when the EASAP has been opened
BUTTON PRESSEDrecognize when one of the specified buttons has been pressed on the EASAP user interface
EXCEL SAVEDEVENT generated following EASA→Save from the EASA Ribbon within an Excel Client (or 'EDC')
POLL REQUESTrecognize when a POLL has fired from the USER INTERFACE
RESULTS COMPLETEDrecognize when a submitted run has completed processing
SUBMIT CHECKrecognize when the submission check has been initiated on the EASAP user interface
SUBMIT COMPLETEDrecognize when a submission has been successfully sent to the EASA Server for processing
TAB SELECTEDrecognize when a User clicks on the tab of a specified TABBED PANE
TABLE SELECTEDrecognize when a User clicks in cells, rows or columns within a specified TABULATED DATA
VALUE CHANGEDrecognize when the value of one of the specified objects has been changed on the EASAP user interface

ACTION

ACTION's
ACTION GROUPParent object for other ACTION's.
CELL REFRESHrefresh data associated with a RANGE REFERENCE either to or from an Excel spreadsheet
CHECK VALUESperform custom defined error checks as defined in its Child ERROR CHECK's
ERROR CHECKdefine a custom error check
CLEAR EXCEL RANGEclear values from cells within specified ranges
CLOSE FORM ACTIONclose a FORM that is open.
CONTROL CALCULATIONsuspend backend tasks or processing for a more responsive interface
CUSTOM ACTIONperform the ACTION's defined through a custom coded object
DATA PROCESSING ACTIONSParent object for DATA PROCESSING ACTION's
DATEstore the current date and/or time in an SCALAR
EXTRACTextract data from a file
SET LISTset an explicit LIST
SET SCALARset an explicit SCALAR
DATABASE ACTIONperform a one time action on a DATABASE
DATABASEdefine the DATABASE on which to perform the action
 CLOSE CONNECTIONafter a READ/WRITE sequence
close the database connection
READexecute a SELECT statement in SQL
WRITEexecute an INSERT, UPDATE or DELETE 
DATABASE TO EXCEL DESKTOPlaunch an Excel Client GUI from within an EASAP
DATE FUNCTIONexecute various operations on dates
EXPORT TO PDFcreate a snapshot of a specified spreadsheet range as a PDF document and saves it on the file system
EMAIL ACTIONcompose and send an email
GET EXCEL FILE ACTIONget the current copy of the Excel spreadsheet from the Excel Server
allow an User to download the spreadsheet from the EASAP
IMAGE EXCEL ACTIONextract a screen capture of cell range or chart for display by an IMAGE in a DIAGRAM
LOG ACTIONa tool for authors to write messages under certain circumstances into the Application Log
MENU ACTIONperform the specified action available in the menus of an EASAP
MODIFY LIST ACTIONalter the value of a LIST in various ways
MODIFY SCALAR ACTIONchange or formats the value of a SCALAR
OPEN BROWSERopen a browser window to the specified URL or EASA web page location
OPEN FORM ACTIONopen a FORM
READ CASE DATApull case data from the Excel Client database into one or more LIST's
READ EXCEL ACTIONread values from specified cell ranges in Excel spreadsheets into specified LIST's
REFRESH OBJECTSrefresh a LIST of objects
RUN ACTIONrun an existing ACTION GROUP by entering it as a parameter
RUN MACRO ACTIONexecute a macro in an Excel spreadsheet
SELECT TAB ACTIONchange the selected TABBED PANE on the EASAP user interface to the specified tab
SET CASE STATUSmanually modify the status field of a case record
SET CUSTOM IDbind an organization's external record identifier to a case record ID in an Excel Client EASAP
SET FOCUS ACTIONassign focus to a GUI object without requiring the mouse or TAB key
SET PROTOTYPEmanipulate LIST's and SCALAR's using the scripting language Groovy
SET STYLE ACTIONdynamically modify a GUI object's Style: parameter
SET VALUE ACTIONset a new value for a visible data entry object
SLEEP ACTIONperform a delay for the specified number of seconds
WRITE EXCEL ACTIONwrite values from specified LIST's into specified cell ranges in Excel spreadsheets

Page Tools