Placeholders - Revision history

G.dimaio at 14:37, 31 October 2013

2013-10-31T14:37:50Z

G.dimaio at 08:46, 24 July 2013

2013-07-24T08:46:43Z

Anonymous at 12:27, 20 February 2012

2012-02-20T12:27:59Z

G.dimaio at 11:16, 20 February 2012

2012-02-20T11:16:47Z

G.dimaio at 11:00, 20 February 2012

2012-02-20T11:00:52Z

Anonymous at 14:33, 8 February 2012

2012-02-08T14:33:53Z

D.franco at 10:47, 31 January 2012

2012-01-31T10:47:00Z

Anonymous at 08:16, 31 January 2012

2012-01-31T08:16:01Z

Anonymous at 08:15, 31 January 2012

2012-01-31T08:15:18Z

Anonymous at 08:12, 31 January 2012

2012-01-31T08:12:50Z

@@ Line 77: / Line 77: @@
 |-
 | [[Placeholders Example|<nowiki>env{{propname}} </nowiki>]] || Returns the value of the ''propname'' environment variable
 |}
 </div>

@@ Line 16: / Line 16: @@
 | [[Placeholders Example|<nowiki>%{{package}}</nowiki>]] || Represents the object package name
 |-
-| [[Placeholders Example|<nowiki>${{propname}} </nowiki>]] || Use this if you want a property previously defined by System. <br/> ''propname'' represents the System property name
+| [[Placeholders Example|<nowiki>${{propname}} </nowiki>]] || Returns the value of the ''propname'' system property
 |-
-| [[Placeholders Example|<nowiki>sp{{propname}} </nowiki>]] || Use this if you want a property previously defined by System. <br/> ''propname'' represents the System property name
+| [[Placeholders Example|<nowiki>sp{{propname}} </nowiki>]] || Returns the value of the ''propname'' system property
 |-
 | [[Placeholders Example|<nowiki>@{{propname}} </nowiki>]] || Use this if you want a property passed as input. <br/> ''propname'' represents the inProperties property name
@@ Line 70: / Line 70: @@
 | [[Placeholders Example|<nowiki>replace{{string::search::subst}}</nowiki>]] || replaces in ''string'' all occurrences of ''search'' with ''replace''
 |}

@@ Line 36: / Line 36: @@
 | [[Placeholders Example|<nowiki>js{{scope::script}}</nowiki>]] || Evaluates a JavaScript script, using the scope ''scope''. The [[GVBuffer]] is added to the scope as ''object'' variable
 |-
-| [[Placeholders Example|<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 name of a connection defined in [[JDBCConnectionBuilder|GVAdapter.xml JDBCConnectionBuilder]] or the JNDI name of a DataSource
+| [[Placeholders Example|<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 name of a connection defined in GVAdapter.xml/[[GVJDBCConnectionBuilder]]] or the JNDI name of a DataSource
 |-
-| [[Placeholders Example|<nowiki>sqllist{{[conn::[::sep]]statement}}</nowiki>]] || Executes a select sql statement and returns the value of the first field of all selected records as  as a 'sep' (default to comma) separated list. <br/> The ''conn'' parameter is the name of a connection defined in [[JDBCConnectionBuilder|GVAdapter.xml JDBCConnectionBuilder]] or the JNDI name of a DataSource
+| [[Placeholders Example|<nowiki>sqllist{{[conn::[::sep]]statement}}</nowiki>]] || Executes a select sql statement and returns the value of the first field of all selected records as  as a 'sep' (default to comma) separated list. <br/> The ''conn'' parameter is the name of a connection defined in GVAdapter.xml/[[GVJDBCConnectionBuilder]] or the JNDI name of a DataSource
 |-
 | [[Placeholders Example|<nowiki>sqltable{{conn::statement}}</nowiki>]] || Executes a select sql statement and returns all values of returned cursor as a XML. <br/> For instance, if the cursor has 3 fields, the returned XML will have following fields:
@@ Line 58: / Line 58: @@
 </RowSet>
 </syntaxhighlight>
-The ''conn'' parameter is the name of a connection defined in [[JDBCConnectionBuilder|GVAdapter.xml JDBCConnectionBuilder]] or the JNDI name of a DataSource
+The ''conn'' parameter is the name of a connection defined in GVAdapter.xml/[[GVJDBCConnectionBuilder]] or the JNDI name of a DataSource
 |-
 | [[Placeholders Example|<nowiki>ognl{{script}}</nowiki>]] || Evaluates a OGNL script. The [[GVBuffer]] is added to the context as ''<nowiki>#object</nowiki>'' variable (and is also the context object on which executes the script)

@@ Line 1: / Line 1: @@
-{{GVESB}} provides some placeholders and metadata. Their numerous applications range from the property definitions and attribute settings to more concrete applications as the evaluations of JavaScript scripts and database queries.
+{{GVESB}} provides some placeholders and metadata. Their numerous applications range from the property definitions and attribute settings to more concrete applications as the evaluations of JavaScript scripts and database queries. Placeholders can be nested.
 Next comes a table with all the metadata used by {{GVESB}} and their description. It is also available for each item a link for deepening into, with concrete examples.
@@ Line 34: / Line 34: @@
 | [[Placeholders Example|<nowiki>xpath{{field://name::path}}</nowiki>]] || If ''field'' begin with ''file://'' the following string must be a name of a file in the classpath on which apply the xpath. Then is read by XMLConfig class
 |-
-| [[Placeholders Example|<nowiki>js{{scope::script}}</nowiki>]] || Evaluates a JavaScript script, using the scope ''scope''. The [[GVBuffer]] is added to the scope as ''object''
+| [[Placeholders Example|<nowiki>js{{scope::script}}</nowiki>]] || Evaluates a JavaScript script, using the scope ''scope''. The [[GVBuffer]] is added to the scope as ''object'' variable
 |-
 | [[Placeholders Example|<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 name of a connection defined in [[JDBCConnectionBuilder|GVAdapter.xml JDBCConnectionBuilder]] or the JNDI name of a DataSource
@@ Line 60: / Line 60: @@
 The ''conn'' parameter is the name of a connection defined in [[JDBCConnectionBuilder|GVAdapter.xml JDBCConnectionBuilder]] or the JNDI name of a DataSource
 |-
-| [[Placeholders Example|<nowiki>ognl{{script}}</nowiki>]] || Evaluates a OGNL script. The [[GVBuffer]] is added to the context as ''object'' (and is also the object on which executes the script)
+| [[Placeholders Example|<nowiki>ognl{{script}}</nowiki>]] || Evaluates a OGNL script. The [[GVBuffer]] is added to the context as ''<nowiki>#object</nowiki>'' variable (and is also the context object on which executes the script)
 |-
 | [[Placeholders Example|<nowiki>escJS{{string}}</nowiki>]] || escapes invalid JavaScript characters from 'string' (ex. ' -> \')

@@ Line 40: / Line 40: @@
 | [[Placeholders Example|<nowiki>sqllist{{[conn::[::sep]]statement}}</nowiki>]] || Executes a select sql statement and returns the value of the first field of all selected records as  as a 'sep' (default to comma) separated list. <br/> The ''conn'' parameter is the name of a connection defined in [[JDBCConnectionBuilder|GVAdapter.xml JDBCConnectionBuilder]] or the JNDI name of a DataSource
 |-
-| [[Placeholders Example|<nowiki>sqltable{{conn::statement}}</nowiki>]] || Executes a select sql statement and returns all values of returned cursor as a XML. <br/> For instance, if the cursor has 3 values, the returned XML will have following fields:
+| [[Placeholders Example|<nowiki>sqltable{{conn::statement}}</nowiki>]] || Executes a select sql statement and returns all values of returned cursor as a XML. <br/> For instance, if the cursor has 3 fields, the returned XML will have following fields:
 <syntaxhighlight lang="XML">
 <RowSet>
@@ Line 64: / Line 64: @@
 | [[Placeholders Example|<nowiki>escJS{{string}}</nowiki>]] || escapes invalid JavaScript characters from 'string' (ex. ' -> \')
 |-
-| [[Placeholders Example|<nowiki>escSQL{{string}}</nowiki>]] || escapes invalid SQL characters from 'string' (ex. ' -> '')
+| [[Placeholders Example|<nowiki>escSQL{{string}}</nowiki>]] || escapes invalid SQL characters from 'string' (ex. ' -> <nowiki>''</nowiki>)
 |-
-| [[Placeholders Example|<nowiki>escXML{{string}}</nowiki>]] || escapes invalid XML characters from 'string' (ex. ' -> &apos;)
+| [[Placeholders Example|<nowiki>escXML{{string}}</nowiki>]] || escapes invalid XML characters from 'string' (ex. ' -> <nowiki>&apos;</nowiki>)
 |-
 | [[Placeholders Example|<nowiki>replace{{string::search::subst}}</nowiki>]] || replaces in ''string'' all occurrences of ''search'' with ''replace''
 |}

@@ Line 3: / Line 3: @@
 Next comes a table with all the metadata used by {{GVESB}} and their description. It is also available for each item a link for deepening into, with concrete examples.
-{|  class="gvtable"
+{|class="gvtable"
 ! Placeholders / Metadata !! Brief description
 |-
-| [[More about Placeholders|fixed]] || You can use a text string
+| [[Placeholders Example|<nowiki>xmlp{{propname}}</nowiki>]] || Used by XML configuration reading framework. Replaces in file ''filename.xml'' the occurrences of <nowiki>xmlp{{prop}}</nowiki> with the prop value defined in the ''filename.properties'' file, before parsing the XML document.
 |-
-| [[More about Placeholders|<nowiki>${{propname}} </nowiki>]] || Use this if you want a property previously defined by System. <br/> ''propname'' represents the System property name
+| [[Placeholders Example|<nowiki>%{{class}}</nowiki>]] || Represents the object class name
 |-
-| [[More about Placeholders|<nowiki>sp{{propname}} </nowiki>]] || Use this if you want a property previously defined by System. <br/> ''propname'' represents the System property name
+| [[Placeholders Example|<nowiki>${{propname}} </nowiki>]] || Use this if you want a property previously defined by System. <br/> ''propname'' represents the System 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
+| [[Placeholders Example|<nowiki>sp{{propname}} </nowiki>]] || Use this if you want a property previously defined by System. <br/> ''propname'' represents the System property name
 |-
-| [[More about Placeholders|<nowiki>timestamp{{pattern}} </nowiki>]] || Returns the current timestamp formatted as ''pattern''
+| [[Placeholders Example|<nowiki>@{{propname}} </nowiki>]] || Use this if you want a property passed as input. <br/> ''propname'' represents the inProperties property name
 |-
-| [[More about Placeholders|<nowiki>dateformat{{date::source-pattern::dest-pattern}} </nowiki>]] || Use this if you want to change the ''date'' format from ''source-pattern'' to ''dest-pattern''
+| [[Placeholders Example|<nowiki>timestamp{{pattern}} </nowiki>]] || Returns the current timestamp formatted as ''pattern''. The pattern syntax is like the ''SimpleDateFormat'' class
 |-
-| [[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''
+| [[Placeholders Example|<nowiki>dateformat{{date::source-pattern::dest-pattern}} </nowiki>]] || Use this if you want to change the ''date'' format from ''source-pattern'' to ''dest-pattern''. the pattern syntax is like the ''SimpleDateFormat'' class
 |-
-| [[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''
+| [[Placeholders Example|<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>js{{scope::script}}</nowiki>]] || Evaluates a JavaScript script, using the scope ''scope''
+| [[Placeholders Example|<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>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
+| [[Placeholders Example|<nowiki>xpath{{field::path}}</nowiki>]] || Parses the inProperties ''field'' value (must contain a XML string), then applies the xpath and returns the found value
 |-
-| [[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
+| [[Placeholders Example|<nowiki>xpath{{field://name::path}}</nowiki>]] || If ''field'' begin with ''file://'' the following string must be a name of a file in the classpath on which apply the xpath. Then is read by XMLConfig class
 |-
-| [[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
+| [[Placeholders Example|<nowiki>js{{scope::script}}</nowiki>]] || Evaluates a JavaScript script, using the scope ''scope''. The [[GVBuffer]] is added to the scope as ''object''
 |-
-| [[More about Placeholders|<nowiki>ognl{{script}}</nowiki>]] || Evaluates a OGNL script
+| [[Placeholders Example|<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 name of a connection defined in [[JDBCConnectionBuilder|GVAdapter.xml JDBCConnectionBuilder]] or the JNDI name of a DataSource
 |}

@@ Line 8: / Line 8: @@
 | [[More about Placeholders|fixed]] || You can use a text string
 |-
-| [[More about Placeholders|<nowiki>${{propname}} </nowiki>]] || Use if you want a property previously defined by System. <br/> ''propname''represents the System property name
+| [[More about Placeholders|<nowiki>${{propname}} </nowiki>]] || Use if you want a property previously defined by System. <br/> ''propname'' represents the System property name
 |-
-| [[More about Placeholders|<nowiki>sp{{propname}} </nowiki>]] || Use if you want a property previously defined by System. <br/> ''propname''represents the System property name
+| [[More about Placeholders|<nowiki>sp{{propname}} </nowiki>]] || Use if you want a property previously defined by System. <br/> ''propname'' represents the System 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>@{{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>]] || Returns the current timestamp formatted as ''pattern''

← Older revision		Revision as of 08:15, 31 January 2012
Line 1:		Line 1:
−	{{GVESB}} 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.	+	{{GVESB}} provides some placeholders and metadata. Their numerous applications range from the property definitions and attribute settings to more concrete applications as the evaluations of JavaScript scripts and database queries.

	Next comes a table with all the metadata used by {{GVESB}} and their description. It is also available for each item a link for deepening into, with concrete examples.		Next comes a table with all the metadata used by {{GVESB}} and their description. It is also available for each item a link for deepening into, with concrete examples.

@@ 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>timestamp{{pattern}} </nowiki>]] || return the current timestamp formatted as ''pattern''
+| [[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>]] || reformat ''date'' from ''source-pattern'' to ''dest-pattern''
+| [[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>]] || evaluate as if-then-else; if ''field'' is equal to cond1...n, return the value of val1...n, otherwise ''default''
+| [[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>]] || evaluate a JavaScript script, using the scope ''scope''
+| [[More about Placeholders|<nowiki>js{{scope::script}}</nowiki>]] || Evaluates a JavaScript script, using the scope ''scope''
 |-
-| [[More about Placeholders|<nowiki>sql{{[conn::]statement}}</nowiki>]] || execute a select sql statement sql and return the value of the first field of the first selected record.<br/> The ''conn'' parameter is the JNDI name of a DataSource, if not defined is used the current connection
+| [[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>]] || execute a select sql statement sql and return 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 not defined is used the current connection
+| [[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>]] || 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>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>]] || evaluate a OGNL script
+| [[More about Placeholders|<nowiki>ognl{{script}}</nowiki>]] || Evaluates a OGNL script
 |}