Placeholders

From GreenVulcano Wiki
Revision as of 10:46, 26 January 2012 by Anonymous (talk) (Created page with "This section contains the placeholders used by {{GVESB}}. # fixed : a text string; # <nowiki>${{propname}} </nowiki> : a System property name; # <nowiki>sp{{propname}} </nowiki...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

This section contains the placeholders used by GreenVulcano® ESB.

  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