Difference between revisions of "Placeholders"
| Line 14: | Line 14: | ||
| [[More about Placeholders|<nowiki>@{{propname}} </nowiki>]] || Use this if you want a property passed as input. <br/> ''propname''represents the inProperties property name | | [[More about Placeholders|<nowiki>@{{propname}} </nowiki>]] || Use this if you want a property passed as input. <br/> ''propname''represents the inProperties property name | ||
|- | |- | ||
| − | | [[More about Placeholders|<nowiki>timestamp{{pattern}} </nowiki>]] || | + | | [[More about Placeholders|<nowiki>timestamp{{pattern}} </nowiki>]] || Returns the current timestamp formatted as ''pattern'' |
|- | |- | ||
| − | | [[More about Placeholders|<nowiki>dateformat{{date::source-pattern::dest-pattern}} </nowiki>]] || | + | | [[More about Placeholders|<nowiki>dateformat{{date::source-pattern::dest-pattern}} </nowiki>]] || Use this if you want t change the ''date'' format from ''source-pattern'' to ''dest-pattern'' |
|- | |- | ||
| − | | [[More about Placeholders|<nowiki>decode{{field[::cond1::val1][::cond2::val2][cond...n::val...n]::default}} </nowiki>]] || | + | | [[More about Placeholders|<nowiki>decode{{field[::cond1::val1][::cond2::val2][cond...n::val...n]::default}} </nowiki>]] || Works as the if-then-else construct: if ''field'' is equal to cond1, return the value of val1, ...; if ''field'' is equal to condn, return the value of valn; otherwise ''default'' |
|- | |- | ||
| − | | [[More about Placeholders|<nowiki>decodeL{{sep::field[::cond1::val1][::cond2::val2][cond...n::val...n]::default}}</nowiki>]] || is equivalent to ''decode'', with the difference that ''condX'' can be a list of values separated by ''sep'' | + | | [[More about Placeholders|<nowiki>decodeL{{sep::field[::cond1::val1][::cond2::val2][cond...n::val...n]::default}}</nowiki>]] || It is equivalent to ''decode'', with the difference that ''condX'' can be a list of values separated by ''sep'' |
|- | |- | ||
| − | | [[More about Placeholders|<nowiki>js{{scope::script}}</nowiki>]] || | + | | [[More about Placeholders|<nowiki>js{{scope::script}}</nowiki>]] || Evaluates a JavaScript script, using the scope ''scope'' |
|- | |- | ||
| − | | [[More about Placeholders|<nowiki>sql{{[conn::]statement}}</nowiki>]] || | + | | [[More about Placeholders|<nowiki>sql{{[conn::]statement}}</nowiki>]] || Executes a select sql statement and returns the value of the first field of the first selected record.<br/> The ''conn'' parameter is the JNDI name of a DataSource, if it is not defined the current connection is used |
|- | |- | ||
| − | | [[More about Placeholders|<nowiki>sqllist{{[conn::]statement}}</nowiki>]] || | + | | [[More about Placeholders|<nowiki>sqllist{{[conn::]statement}}</nowiki>]] || Executes a select sql statement and returns the value of the first field of all selected records as a comma separated list. <br/> The ''conn'' parameter is the JNDI name of a DataSource, if it is not defined the current connection is used |
|- | |- | ||
| − | | [[More about Placeholders|<nowiki>sqltable{{conn::statement}}</nowiki>]] || | + | | [[More about Placeholders|<nowiki>sqltable{{conn::statement}}</nowiki>]] || Executes a select sql statement and returns all values of returned cursor as an XML. <br/> The ''conn'' parameter is the JNDI name of a DataSource |
|- | |- | ||
| − | | [[More about Placeholders|<nowiki>ognl{{script}}</nowiki>]] || | + | | [[More about Placeholders|<nowiki>ognl{{script}}</nowiki>]] || Evaluates a OGNL script |
|} | |} | ||
Revision as of 08:12, 31 January 2012
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}} | Returns the current timestamp formatted as pattern |
| dateformat{{date::source-pattern::dest-pattern}} | Use this if you want t change the date format from source-pattern to dest-pattern |
| decode{{field[::cond1::val1][::cond2::val2][cond...n::val...n]::default}} | Works as the if-then-else construct: if field is equal to cond1, return the value of val1, ...; if field is equal to condn, return the value of valn; otherwise default |
| decodeL{{sep::field[::cond1::val1][::cond2::val2][cond...n::val...n]::default}} | It is equivalent to decode, with the difference that condX can be a list of values separated by sep |
| js{{scope::script}} | Evaluates a JavaScript script, using the scope scope |
| sql{{[conn::]statement}} | Executes a select sql statement and returns the value of the first field of the first selected record. The conn parameter is the JNDI name of a DataSource, if it is not defined the current connection is used |
| sqllist{{[conn::]statement}} | Executes a select sql statement and returns 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 it is not defined the current connection is used |
| 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}} | Evaluates a OGNL script |
