User Tools

Site Tools


DATA PROCESSING Objects


A Child object to DATA PROCESSING→SCALAR performs data manipulation on SCALAR's and/or LIST's and returns a single value as a SCALAR.

DATA PROCESSING→SCALAR

SCALAR DATA PROCESSING
COMPUTEStores a value of an expression containing a SCALAR
CONTACT DETAILSReturns user name, full name or e-mail address of user
CUSTOM SCALARReturns SCALAR generated using custom Java code within the EASA API
DATE COMPARISONCompares two date SCALAR's against each other
DATE CONVERSIONConverts date SCALAR's from one format to another
EXPANDCreates a single instance of one or more lines of text
FILE SYSTEMDetermines existence of a file or returns its full path or URL
SCALAR DOR VALUEStores a SCALAR. Mainly for use with a CUSTOM ACTION.
FORMATPerforms formatting on a numerical SCALAR DOR
GET INDEXRetrieves an index from a LIST given a value to find in the LIST
GET VALUERetrieves a value from a LIST given a location or index within the LIST
IS VALIDDetermines if another object value is valid
MAPMapping from a LIST (Inputs:) to a new value specified in another LIST (Outputs:)
REPLACEReplaces part of a string of text
SEARCHFinds the location of text within a string of text
STATISTICSComputes statistics: average, count, maximum, minimum, first, last, standard deviation, sum
STRINGText operations on a string (eg. converts to upper case)
SUBSTRINGExtracts part of a string of text based on start and end character positions
SYSTEM PROPERTYGenerates a SCALAR from a Java system property

DATA PROCESSING→LIST

A Child object under DATA PROCESSING→LIST performs data manipulation on SCALAR's and/or LIST's and returns a LIST.

LIST DATA PROCESSING
AUTO LISTGenerates a LIST of numbers or letters given a list size
CONCATENATEConcatenates LIST's and/or SCALAR's together into one LIST
CUMULATIVE SUMComputes a LIST by cumulatively summing the values of another LIST
CUSTOM LISTReturns LIST of values generated using custom Java code within the EASA API
CUSTOM MULTI-LISTReturns a LIST of new LIST names generated using custom Java code within the EASA API
CUTCuts out a subset of values from an existing LIST
DATABASEUses READ's to retrieve list data from a database
LIST DOR VALUEStores a LIST of values. Mainly for use with CUSTOM ACTION's
EXTRACTUses REPEAT's and FIND's to extract LIST data from a file
INTERLEAVECombines existing lists to produce one interleaved LIST
MAPPED LISTSelects a LIST based on a SCALAR input value
OBJECT QUERYRetrieves name, value and parameter value information from other objects
REPEATED COMPUTEStores repeated values of an expression based on a given LIST
REPEATED DATE CONVERSIONConverts a LIST of dates from one date format to another
REPEATED EXPANDCreates a LIST containing one or more lines of text for each value of a given LIST
REPEATED FORMATFormats a LIST DOR of numerical values
REPEATED GET INDEXRetrieves indexes from a LIST given the values to find in the LIST
REPEATED GET VALUERetrieves 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 REPLACEReplaces text within a string, repeated for each string in LIST.
REPEATED SEARCHFinds the location of text within a string, repeated for each string in a LIST.
REPEATED STRINGText operations on a string (eg. converts to upper case), repeated for each string in LIST.
REPEATED SUBSTRINGExtracts part of a string based on start and end character positions, repeated for each string in LIST.
SETPerforms set operations such as intersection on a pair of LIST's.
SORTProduces a LIST containing the values of another LIST sorted alphanumerically based on its own or yet another LIST's values
SPLITSplits a text string into a LIST given a separator found in the text string
UNIQUE LIST DORUsed to reduce a LIST of elements into a set of unique elements.
XPATHExtraction of data from XML using XPath


Page Tools