Excel-call - Revision history

G.dimaio at 20:51, 29 October 2015

2015-10-29T20:51:04Z

G.dimaio: /* GVExcelReport */

2015-10-29T20:43:19Z

‎GVExcelReport

Anonymous: /* prep-statement */

2012-11-12T13:37:58Z

‎prep-statement

Anonymous: /* prep-statement */

2012-11-12T13:37:39Z

‎prep-statement

Anonymous: /* prep-statement */

2012-11-12T13:37:16Z

‎prep-statement

Anonymous: /* prep-statement */

2012-11-12T13:35:29Z

‎prep-statement

Anonymous: /* prep-statement */

2012-11-12T13:34:18Z

‎prep-statement

Anonymous: /* prep-statement */

2012-11-12T13:33:42Z

‎prep-statement

Anonymous: /* Sheet */

2012-04-10T10:01:24Z

‎Sheet

Anonymous: /* {{VULCON}} / {{GVCONSOLE}} Configuration */

2012-02-09T16:58:04Z

‎{{VULCON}} / {{GVCONSOLE}} Configuration

← Older revision		Revision as of 20:51, 29 October 2015
Line 101:		Line 101:
	\| id \|\| optional \|\| prep-statement Id.		\| id \|\| optional \|\| prep-statement Id.
	\|}		\|}
		+
		+	==Examples==
		+	The following example shows the configuration generated from {{L_VULCON}} or {{L_GVCONSOLE}} when you configure a [[excel-call]] operation in SQL mode:
		+
		+	<syntaxhighlight lang="XML"><?xml version="1.0" encoding="UTF-8"?>
		+	<GVSystems name="SYSTEMS" type="module">
		+	<Systems>
		+	<System id-system="system-name" system-activation="on">
		+	<Channel id-channel="CHANNEL_NAME">
		+	<excel-call class="it.greenvulcano.gvesb.virtual.excel.GVExcelCallOperation"
		+	name="listPerson" type="call">
		+	<GVExcelReport format="default" group="CREDIT"
		+	jdbc-connection="ds.gv_test" name="listPerson">
		+	<Sheet id="1" name="Person List"
		+	title="Person List - timestamp{{dd/MM/yyyy HH:mm:ss}}">
		+	<statement type="select"><![CDATA[select p.NAME as "Name", p.BIRTHDATE as "Birth Date", c.NAME as "City"
		+	from PERSON p, CITY c
		+	where p.ID_CITY = c.ID
		+	decode{{@{{NAME}}::NULL::::and p.NAME='@{{NAME}}'}}
		+	order by c.NAME, p.NAME]]></statement>
		+	</Sheet>
		+	<Sheet id="2" name="Credit Card List"
		+	title="Credit Card List - timestamp{{dd/MM/yyyy HH:mm:ss}}">
		+	<statement type="select"><![CDATA[select p.NAME as "Name", cc.CNUMBER as "Card Number", cc.CREDIT as "Credit", decode(cc.ENABLED, 'Y', 'Yes', 'No') as "Active"
		+	from PERSON p, CREDIT_CARD cc
		+	where p.ID = cc.ID_OWNER
		+	decode{{@{{NAME}}::NULL::::and p.NAME='@{{NAME}}'}}
		+	order by p.NAME]]></statement>
		+	</Sheet>
		+	</GVExcelReport>
		+	</excel-call>
		+	</Channel>
		+	</System>
		+	</Systems>
		+	</GVSystems>
		+	</syntaxhighlight>
		+
		+
		+	The following example shows the configuration generated from {{L_VULCON}} or {{L_GVCONSOLE}} when you configure a [[excel-call]] operation in XML mode:
		+
		+	<syntaxhighlight lang="XML"><?xml version="1.0" encoding="UTF-8"?>
		+	<GVSystems name="SYSTEMS" type="module">
		+	<Systems>
		+	<System id-system="system-name" system-activation="on">
		+	<Channel id-channel="CHANNEL_NAME">
		+	<excel-call class="it.greenvulcano.gvesb.virtual.excel.GVExcelCallOperation"
		+	name="TestXmlExcel" type="call">
		+	<GVExcelReport format="default" group="AAA_GRP" mode="xml"
		+	jdbc-connection="something" name="TestXmlExcel">
		+	<Sheet id="1" name="Name Sheet 1 of TestXmlExcel" title="Title Sheet 1 of TestXmlExcel"
		+	fields="Name,Surname,BirthDate,City">
		+	<statement id="1" type="select"><![CDATA[/RowSet/data[@id="0"]/row]]></statement>
		+	</Sheet>
		+	<Sheet id="2" name="Name Sheet 2 of TestXmlExcel" title="Title Sheet 2 of TestXmlExcel"
		+	fields="Name,Surname,CardNumber">
		+	<statement id="2" type="select"><![CDATA[/RowSet/data[@id="1"]/row]]></statement>
		+	</Sheet>
		+	</GVExcelReport>
		+	</excel-call>
		+	</Channel>
		+	</System>
		+	</Systems>
		+	</GVSystems>
		+	</syntaxhighlight>
		+	And the following is a sample input XML:
		+	<syntaxhighlight lang="XML"><?xml version="1.0" encoding="UTF-8"?>
		+	<RowSet>
		+	<data id="0">
		+	<row BirthDate="05/02/1980" City="MILANO" Name="ANTONIO" Surname="ROSSI" blablabla="ccmocmso"/>
		+	<row BirthDate="15/08/1970" City="MILANO" Name="MARIO" Surname="BIANCHI" blablabla="ccmocmso"/>
		+	<row BirthDate="02/10/1979" City="ROMA" Name="ANCO" Surname="MARZIO" blablabla="ccmocmso"/>
		+	<row BirthDate="10/07/1984" City="NAPOLI" Name="CIRO" Surname="ESPOSITO" blablabla="ccmocmso"/>
		+	</data>
		+	<data id="1">
		+	<row CardNumber="1111222233338888" Name="ANTONIO" Surname="ROSSI" blablabla="ccmocmso"/>
		+	<row CardNumber="1234123415555666" Name="MARIO" Surname="BIANCHI" blablabla="ccmocmso"/>
		+	<row CardNumber="1111222233335555" Name="ANCO" Surname="MARZIO" blablabla="ccmocmso"/>
		+	<row CardNumber="1111222233336666" Name="CIRO" Surname="ESPOSITO" blablabla="ccmocmso"/>
		+	</data>
		+	</RowSet>
		+	</syntaxhighlight>

@@ Line 38: / Line 38: @@
 | format || optional || Name of the style of the report. Default ''default''.
 |}
 Its subelements are:
@@ Line 59: / Line 70: @@
 | jdbc-connection || optional || JNDI name of a DataSource. Default to Report connection.
 |}
 and its sub-elements:

@@ Line 73: / Line 73: @@
 ! Attribute !! Type !! Description
 |-
-| type || required || Must be '''Excel Sheet: insert|update|callsp'''. The attribute's admitted values are:
+| type || required ||
 * select
 * insert

@@ Line 73: / Line 73: @@
 ! Attribute !! Type !! Description
 |-
-| type || required || This attribute cannot be null.
+| type || required || Must be '''Excel Sheet: insert|update|callsp'''. The attribute's admitted values are:
 * select
 * insert

@@ Line 73: / Line 73: @@
 ! Attribute !! Type !! Description
 |-
-| type || required || Must be 'Excel Sheet (insert|update|callsp)'. The attribute's admitted values are:
+| type || required || This attribute cannot be null.
 * select
 * insert

@@ Line 60: / Line 60: @@
 |}
-and its subelements:
+and its sub-elements:
-* Description
+* [[Description]]
-* prep-statement
+* [[#prep-statement|prep-statement]]
 * [[statement]]

@@ Line 6: / Line 6: @@
 The excel-call Element is used by [[Channel]] and [[routed-call]]. It has the following attributes:
-* ''type'': call.
+{|class="gvtable"
-* ''class'': it.greenvulcano.gvesb.virtual.excel.GVExcelCallOperation.
+! Attribute !! Type !! Description
-* ''name'': Operation name. Used in the [[Flow]] section to associate workflow nodes to VCL operations.
+|-
-* ''group'': Reports group name.
+| type || fixed || This attribute must assume the value '''call'''.
-* ''report'': Report name.
+|-
 and the subelements:
@@ Line 19: / Line 27: @@
 Defines the configuration elements of an Excel report. It is used by '''excel-call''' and [[excelreader-call]] and has the following attributes:
-* ''name'': Report name
+{|class="gvtable"
-* ''group'': Report group. Default Generic.
+! Attribute !! Type !! Description
-* ''jdbc-connection'': JNDI name of a DataSource.
+|-
-* ''format'': Name of the style of the report. Default ''default''.
+| name || required ||Report name
 Its subelements are:
@@ Line 31: / Line 46: @@
 This element defines the configuration of each sheet of the Report.
 The Sheet Element is used by '''GVExcelReport'''. Its attributes are:
-* ''id'': Sheet id.
+{|class="gvtable"
-* ''name'': Sheet name.
+! Attribute !! Type !! Description
-* ''title'': Sheet title.
+|-
-* ''jdbc-connection'': JNDI name of a DataSource. Default to Report connection.
+| id || required || Sheet id.
 and its subelements:
@@ Line 50: / Line 70: @@
 Its attributes are:
-* ''type'': Must be "Excel Sheet : insert|update|callsp". The attribute's admitted values are:
+{|class="gvtable"
-** select
+! Attribute !! Type !! Description
-** insert
+|-
-** update
+| type || required || Must be "Excel Sheet : insert|update|callsp". The attribute's admitted values are:
-** callsp
+* select
-* ''id'': prep-statement Id.
+* insert