G.dimaio: Created page with "==Description== The TableRetriever element allows you to define a helper to use into the XSL transformations. We define the functions that run SQL select and return the result ..."

2012-05-22T14:19:24Z

Created page with "==Description== The TableRetriever element allows you to define a helper to use into the XSL transformations. We define the functions that run SQL select and return the result ..."

New page

==Description==

The TableRetriever element allows you to define a helper to use into the XSL transformations.

We define the functions that run SQL select and return the result as an XML string in the following form:
<syntaxhighlight lang="XML">
<?xml version="1.0" encoding="UTF-8"?>
<RowSet>
<data>
<row>
<col>value1</col>
<col>value2</col>
<col>value3</col>
</row>
<row>
<col>value4</col>
<col>value5</col>
<col>value6</col>
</row>
..
<row>
<col>valuex</col>
<col>valuey</col>
<col>valuez</col>
</row>
</data>
</RowSet>
</syntaxhighlight>

The statement to be executed can contain metadata resolved at runtime.

=={{GVESB}} configuration==

TableRetriever element is used by [[Retriever_Config|RetrieverConfig]].

The following table shows its attributes:
{|class="gvtable"
! Attribute !! Type !! Description
|-
| type || fixed || retriever (unmodifiable)
|-
| class || fixed || it.greenvulcano.gvesb.datahandling.utils.TableRetriever
|}

Might contain the sub-elements:
* [[Description]]
* [[DataRetriever]]

===An example===

Define the following TableRetriever:
<syntaxhighlight lang="XML">
<TableRetriever class="it.greenvulcano.gvesb.datahandling.utils.TableRetriever" type="retriever">
<DataRetriever cacheable="true" method="..." signature="...">
...
</DataRetriever>
<DataRetriever method="..." signature="...">
...
</DataRetriever>
</TableRetriever>
</syntaxhighlight>

to be applied to the transformation:
<syntaxhighlight lang="XML">
......
<xsl:element name="col">
<xsl:value-of select="java:it.greenvulcano.gvesb.datahandling.utils.TableRetriever.getData('....',.....)"/>
</xsl:element>
</syntaxhighlight>

TableRetriever - Revision history

G.dimaio: Created page with "==Description== The TableRetriever element allows you to define a helper to use into the XSL transformations. We define the functions that run SQL select and return the result ..."