DataRetriever
Defines a helper function.
Can contains the following placeholders:
1 - fixed : a text string;
2 - $Template:Propname : a System property name;
3 - spTemplate:Propname : a System property name;
4 - @Template:Propname : a inProperties property name;
5 - timestampTemplate:Pattern : return the current timestamp formatted as 'pattern'
6 - dateformatTemplate:Date::source-pattern::dest-pattern : reformat 'date' from 'source-pattern' to 'dest-pattern'
7 - decode{{field[::cond1::val1][::cond2::val2][cond...n::val...n]::default}} :
evaluate as if-then-else; if 'field' is equal to cond1...n,
return the value of val1...n, otherwise 'default'
8 - decodeL{{sep::field[::cond1::val1][::cond2::val2][cond...n::val...n]::default}} :
is equivalent to 'decode', with the difference that 'condX'
can be a list of values separated by 'sep'
9 - jsTemplate:Scope::script : evaluate a JavaScript script, using the scope 'scope'
10 - sqlTemplate:Conn::statement : execute a select sql statement sql and return the value of
the first field of the first selected record.
The 'conn' parameter is the JNDI name of a DataSource
11 - sqllist{{conn[::sep]::statement}}
: execute a select sql statement sql and return the value of
the first field of all selected records as a 'sep' separated list.
The 'conn' parameter is the JNDI name of a DataSource
The 'sep' parameter defaults to comma
12 - sqltableTemplate:Conn::statement
: executes a select sql statement and returns all values of
returned cursor as an XML.
The 'conn' parameter is the JNDI name of a DataSource
13 - ognlTemplate:Script : evaluate a OGNL script