Statement

This section contains the statement to be evaluated which can contains the following placeholders:

1. fixed : a text string;
2. ${{propname}}  : a System property name;
3. sp{{propname}}  : a System property name;
4. @{{propname}}  : a inProperties property name;
5. timestamp{{pattern}} : return the current timestamp formatted as pattern
6. dateformat{{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. js{{scope::script}} : evaluate a JavaScript script, using the scope scope
10. sql{{[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, if not defined is used the current connection
11. sqllist{{[conn::]statement}}: execute a select sql statement sql and return the value of the first field of all selected records as a comma separated list.
    The conn parameter is the JNDI name of a DataSource, if not defined is used the current connection
12. sqltable{{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. ognl{{script}} : evaluate a OGNL script

The Statement element has the following parameters:

• type:

 Must be:

   DBOSelect          : select
   DBOInsert          : insert
   DBOUpdate          : update
   DBOInsertOrUpdate  : insert|update
   DBOUpdateOrInsert  : insert|update
   DBOCallSP          : callsp

   Excel Sheet        : select

• id: Pattern: ! [0-9]* ! set a integer value