Placeholders
This section contains the placeholders used by GreenVulcano® ESB.
- fixed : a text string;
- ${{propname}} : a System property name;
- sp{{propname}} : a System property name;
- @{{propname}} : a inProperties property name;
- timestamp{{pattern}} : return the current timestamp formatted as pattern
- dateformat{{date::source-pattern::dest-pattern}} : reformat date from 'source-pattern to dest-pattern
- 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
- 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
- js{{scope::script}} : evaluate a JavaScript script, using the scope scope
- 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 - 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 - 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 - ognl{{script}} : evaluate a OGNL script