Global Type: reportOutputData


General Description

Output data as a result of report run

Name Type Attributes Description
metaData anyDataType optional If the returnMeta input parameter is set to 'true', then the <metaData> element will be returned with a data structure describing the database column attributes associated with each column in the result set.

Example:

  <metaData>
    <res_column_name
        type="VARCHAR" 
        column="the_column_name"
        table="the_table" 
        size="20" 
        scale="0" 
        precision="0" 
        primaryKey="yes|no" 
        unsigned="yes|no" 
        autoIncrement="yes|no" 
        nullable="yes|no"/>
    ...
  </metaData>
row anyDataType optional
minOccurs=0
maxOccurs=unbounded
The data returned from this operation is dependant on the result of the SQL query. The result set is formatted in a standard way and consists of (optional) meta data as well as zero or more rows of data.

Example:

  <rowData>
    <row>
      <res_column_name>the_column_value</column_name>
      <res_column_name>the_column_value</column_name>
      ...
    </row>
    <row>
      <res_column_name>the_column_value</column_name>
      <res_column_name>the_column_value</column_name>
      ...
    </row>
	...
  </rowData>

<xs:complexType name="reportOutputData">
<xs:annotation>
<xs:documentation>
<![CDATA[Output data as a result of report run]]>
</xs:documentation>
</xs:annotation>
<xs:sequence>
<xs:element name="metaData" type="anyDataType" minOccurs="0">
<xs:annotation>
<xs:documentation>
<![CDATA[
If the <b>returnMeta</b> input parameter is set to 'true', then the &lt;metaData&gt; element
will be returned with a data structure describing the database column attributes associated with each
column in the result set.
<h3>Example:</h3>
<pre>
&lt;metaData&gt;
&lt;res_column_name
type="VARCHAR"
column="the_column_name"
table="the_table"
size="20"
scale="0"
precision="0"
primaryKey="yes|no"
unsigned="yes|no"
autoIncrement="yes|no"
nullable="yes|no"/&gt;
...
&lt;/metaData&gt;
</pre>
]]>
</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element name="row" type="anyDataType" minOccurs="0" maxOccurs="unbounded">
<xs:annotation>
<xs:documentation>
<![CDATA[
The data returned from this operation is dependant on the result of the SQL query. The result set
is formatted in a standard way and consists of (optional) meta data as well as zero or more rows of
data.
<br/><br/>
<h3>Example:</h3>
<pre>
&lt;rowData&gt;
&lt;row&gt;
&lt;res_column_name&gt;the_column_value&lt;/column_name&gt;
&lt;res_column_name&gt;the_column_value&lt;/column_name&gt;
...
&lt;/row&gt;
&lt;row&gt;
&lt;res_column_name&gt;the_column_value&lt;/column_name&gt;
&lt;res_column_name&gt;the_column_value&lt;/column_name&gt;
...
&lt;/row&gt;
...
&lt;/rowData&gt;
</pre>
]]>
</xs:documentation>
</xs:annotation>
</xs:element>
</xs:sequence>
</xs:complexType>
Powered by Hornbill, for more information click here. (page served by Esp.hornbill.ServerService, 8.0.0.3141.)