Difference between revisions of "Excel-call"
(→prep-statement) |
(→GVExcelReport) |
||
| Line 38: | Line 38: | ||
| format || optional || Name of the style of the report. Default ''default''. | | format || optional || Name of the style of the report. Default ''default''. | ||
|} | |} | ||
| + | |||
| + | <div class="version_ge3.4.0.10"> | ||
| + | {|class="gvtable" | ||
| + | ! Attribute !! Type !! Description | ||
| + | |- | ||
| + | | mode || optional || Defines the source of the data to be converted in Excel file: | ||
| + | *sql: the data are extracted from a DB though an SQL statement | ||
| + | *xml: the data are extracted from an XML document contained into GVBuffer.object field | ||
| + | Default to sql. | ||
| + | |} | ||
| + | </div> | ||
Its subelements are: | Its subelements are: | ||
| Line 59: | Line 70: | ||
| jdbc-connection || optional || JNDI name of a DataSource. Default to Report connection. | | jdbc-connection || optional || JNDI name of a DataSource. Default to Report connection. | ||
|} | |} | ||
| + | |||
| + | <div class="version_ge3.4.0.10"> | ||
| + | {|class="gvtable" | ||
| + | ! Attribute !! Type !! Description | ||
| + | |- | ||
| + | | fields || optional || Useful only for XML mode, defines the list of (row) element's attributes (and their order) to be shown in the Excel sheet. | ||
| + | |} | ||
| + | </div> | ||
and its sub-elements: | and its sub-elements: | ||
Revision as of 20:43, 29 October 2015
Contents
Description
The GreenVulcano® ESB plugin excell-call allows you to define the information needed to generate Excel reports from a select on the DB.
VulCon / GV Console Configuration
The excel-call Element is used by Channel and routed-call. It has the following attributes:
| Attribute | Type | Description |
|---|---|---|
| type | fixed | This attribute must assume the value call. |
| class | fixed | This attribute must assume the value it.greenvulcano.gvesb.virtual.excel.GVExcelCallOperation. |
| name | required | Operation name. Used in the Flow section to associate workflow nodes to VCL operations. |
| group | optional | Reports group name. |
| report | optional | Report name. |
and the subelements:
- Description
- GVExcelReport
GVExcelReport
Defines the configuration elements of an Excel report. It is used by excel-call and excelreader-call and has the following attributes:
| Attribute | Type | Description |
|---|---|---|
| name | required | Report name |
| group | optional | Report group. Default Generic. |
| jdbc-connection | required | JNDI name of a DataSource. |
| format | optional | Name of the style of the report. Default default. |
| Attribute | Type | Description |
|---|---|---|
| mode | optional | Defines the source of the data to be converted in Excel file:
Default to sql. |
Its subelements are:
- Description
- Sheet(s)
Sheet
This element defines the configuration of each sheet of the Report.
The Sheet Element is used by GVExcelReport. Its attributes are:
| Attribute | Type | Description |
|---|---|---|
| id | required | Sheet id. |
| name | required | Sheet name. |
| title | optional | Sheet title. |
| jdbc-connection | optional | JNDI name of a DataSource. Default to Report connection. |
| Attribute | Type | Description |
|---|---|---|
| fields | optional | Useful only for XML mode, defines the list of (row) element's attributes (and their order) to be shown in the Excel sheet. |
and its sub-elements:
prep-statement
Preparation statement for Excel report generation. Are executed after the report statement. Can contains placeholders.
Its attributes are:
| Attribute | Type | Description |
|---|---|---|
| type | required |
Must be Excel Sheet: insert|update|callsp. The attribute's admitted values are:
|
| id | optional | prep-statement Id. |
