Placeholders
GreenVulcano® ESB provides some placeholders and metadata. Their numerous applications ranging from the definition of the properties and setting attributes of the elements useful in the development of the flow to more concrete applications as the evaluations of JavaScript scripts and database queries.
Next comes a table with all the metadata used by GreenVulcano® ESB and their description. It is also available for each item a link for deepening into, with concrete examples.
| Placeholders / Metadata | Brief description |
|---|---|
| fixed | You can use a text string |
| ${{propname}} | Use if you want a property previously defined by System. propnamerepresents the System property name |
| sp{{propname}} | Use if you want a property previously defined by System. propnamerepresents the System property name |
| @{{propname}} | Use this if you want a property passed as input. propnamerepresents the 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 |
