DataRetriever

DataRetriever defines a helper function. 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
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. 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