Author: tom.baeyens(a)jboss.com
Date: 2009-08-31 09:54:17 -0400 (Mon, 31 Aug 2009)
New Revision: 5606
Modified:
jbpm4/tags/jbpm-4.1/modules/integration/report/src/main/resources/overall_activity.rptdesign
Log:
merged the overall report fix to tag jbpm-4.1
Modified:
jbpm4/tags/jbpm-4.1/modules/integration/report/src/main/resources/overall_activity.rptdesign
===================================================================
---
jbpm4/tags/jbpm-4.1/modules/integration/report/src/main/resources/overall_activity.rptdesign 2009-08-31
13:03:47 UTC (rev 5605)
+++
jbpm4/tags/jbpm-4.1/modules/integration/report/src/main/resources/overall_activity.rptdesign 2009-08-31
13:54:17 UTC (rev 5606)
@@ -2,16 +2,6 @@
<report
xmlns="http://www.eclipse.org/birt/2005/design"
version="3.2.16" id="1">
<property name="createdBy">Eclipse BIRT Designer Version
2.3.0.v20080606 Build <2.3.0.v20080618-0630></property>
<property name="units">in</property>
- <list-property name="propertyBindings">
- <structure>
- <property name="name">queryText</property>
- <property name="id">249</property>
- </structure>
- <structure>
- <property name="name">queryTimeOut</property>
- <property name="id">249</property>
- </structure>
- </list-property>
<property
name="iconFile">/templates/blank_report.gif</property>
<property name="layoutPreference">fixed layout</property>
<property name="bidiLayoutOrientation">ltr</property>
@@ -24,36 +14,36 @@
</oda-data-source>
</data-sources>
<data-sets>
- <oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet"
name="process_definition_counts" id="249">
+ <oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet"
name="proc_count" id="388">
<list-property name="columnHints">
<structure>
- <property
name="columnName">PROCESS_DEFINITION</property>
- <property
name="displayName">PROCESS_DEFINITION</property>
+ <property
name="columnName">process_definition</property>
+ <property
name="displayName">process_definition</property>
</structure>
<structure>
- <property
name="columnName">TOTAL_NR_OF_INSTANCES</property>
- <property
name="displayName">TOTAL_NR_OF_INSTANCES</property>
+ <property
name="columnName">total_nr_of_instances</property>
+ <property
name="displayName">total_nr_of_instances</property>
</structure>
<structure>
- <property
name="columnName">ACTIVE_INSTANCES</property>
- <property
name="displayName">ACTIVE_INSTANCES</property>
+ <property
name="columnName">active_instances</property>
+ <property
name="displayName">active_instances</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
- <property
name="name">PROCESS_DEFINITION</property>
+ <property
name="name">process_definition</property>
<property
name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
- <property
name="name">TOTAL_NR_OF_INSTANCES</property>
+ <property
name="name">total_nr_of_instances</property>
<property
name="dataType">integer</property>
</structure>
<structure>
<property name="position">3</property>
- <property
name="name">ACTIVE_INSTANCES</property>
+ <property
name="name">active_instances</property>
<property
name="dataType">integer</property>
</structure>
</list-property>
@@ -62,31 +52,31 @@
<list-property name="resultSet">
<structure>
<property name="position">1</property>
- <property
name="name">PROCESS_DEFINITION</property>
- <property
name="nativeName">PROCESS_DEFINITION</property>
+ <property
name="name">process_definition</property>
+ <property
name="nativeName">process_definition</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
- <property
name="name">TOTAL_NR_OF_INSTANCES</property>
- <property
name="nativeName">TOTAL_NR_OF_INSTANCES</property>
+ <property
name="name">total_nr_of_instances</property>
+ <property
name="nativeName">total_nr_of_instances</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">3</property>
- <property
name="name">ACTIVE_INSTANCES</property>
- <property
name="nativeName">ACTIVE_INSTANCES</property>
+ <property
name="name">active_instances</property>
+ <property
name="nativeName">active_instances</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
</list-property>
- <property name="queryText">SELECT hpi.PROCDEFID_
process_definition, COUNT(hpi.DBID_) total_nr_of_instances,
-(SELECT COUNT(DBID_) FROM JBPM4_HIST_PROCINST WHERE PROCDEFID_ = hpi.PROCDEFID_ AND END_
IS NULL) active_instances
+ <property name="queryText">SELECT hpi.PROCDEFID_
"process_definition", COUNT(hpi.DBID_) "total_nr_of_instances",
+(SELECT COUNT(DBID_) FROM JBPM4_HIST_PROCINST WHERE PROCDEFID_ = hpi.PROCDEFID_ AND END_
IS NULL) "active_instances"
FROM JBPM4_HIST_PROCINST hpi
GROUP BY PROCDEFID_
-ORDER BY active_instances DESC</property>
+ORDER BY "active_instances"</property>
<xml-property name="designerValues"><![CDATA[<?xml
version="1.0" encoding="UTF-8"?>
<model:DesignValues
xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/desi...
xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaMod...
<Version>1.0</Version>
@@ -95,18 +85,18 @@
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
- <design:name>PROCESS_DEFINITION</design:name>
+ <design:name>process_definition</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
- <design:precision>2147483647</design:precision>
+ <design:precision>255</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
- <design:displayName>PROCESS_DEFINITION</design:displayName>
+ <design:displayName>process_definition</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
- <design:label>PROCESS_DEFINITION</design:label>
+ <design:label>process_definition</design:label>
<design:formattingHints>
<design:displaySize>255</design:displaySize>
</design:formattingHints>
@@ -114,39 +104,39 @@
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
- <design:name>TOTAL_NR_OF_INSTANCES</design:name>
+ <design:name>total_nr_of_instances</design:name>
<design:position>2</design:position>
- <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
- <design:precision>10</design:precision>
+ <design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
+ <design:precision>21</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
- <design:displayName>TOTAL_NR_OF_INSTANCES</design:displayName>
+ <design:displayName>total_nr_of_instances</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
- <design:label>TOTAL_NR_OF_INSTANCES</design:label>
+ <design:label>total_nr_of_instances</design:label>
<design:formattingHints>
- <design:displaySize>11</design:displaySize>
+ <design:displaySize>21</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
- <design:name>ACTIVE_INSTANCES</design:name>
+ <design:name>active_instances</design:name>
<design:position>3</design:position>
- <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
- <design:precision>10</design:precision>
+ <design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
+ <design:precision>21</design:precision>
<design:scale>0</design:scale>
- <design:nullability>NotNullable</design:nullability>
+ <design:nullability>Nullable</design:nullability>
<design:uiHints>
- <design:displayName>ACTIVE_INSTANCES</design:displayName>
+ <design:displayName>active_instances</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
- <design:label>ACTIVE_INSTANCES</design:label>
+ <design:label>active_instances</design:label>
<design:formattingHints>
- <design:displaySize>11</design:displaySize>
+ <design:displaySize>21</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
@@ -155,7 +145,7 @@
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
- <oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet"
name="process_performance" id="315">
+ <oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet"
name="proc_perf" id="391">
<list-property name="columnHints">
<structure>
<property
name="columnName">PROCESS_DEFINITION</property>
@@ -213,26 +203,17 @@
<property name="nativeDataType">8</property>
</structure>
</list-property>
- <property name="queryText">// The STDDEV function isn't a
standard function
-// (eg doesn't work on HSQLDB), so we need to
-// calculate the stddev old-skool way here
-
-// Secondly, bitwise operators aren't SQL standard
-// either, so we must copy the same statement twice
-// to do a ^2
-
-SELECT
-hpi.PROCDEFID_ PROCESS_DEFINITION,
-AVG(hpi.DURATION_) AVERAGE_DURATION,
+ <property name="queryText">SELECT
+hpi.PROCDEFID_ "PROCESS_DEFINITION",
+AVG(hpi.DURATION_) "AVERAGE_DURATION",
sqrt(
- sum
- (
+ sum(
(hpi.DURATION_ - (SELECT AVG(DURATION_) FROM JBPM4_HIST_PROCINST WHERE END_ IS NOT
NULL AND PROCDEFID_ = hpi.PROCDEFID_))
*
(hpi.DURATION_ - (SELECT AVG(DURATION_) FROM JBPM4_HIST_PROCINST WHERE END_ IS NOT
NULL AND PROCDEFID_ = hpi.PROCDEFID_))
) / count(*)
-) STDDEV_DURATION
+) "STDDEV_DURATION"
FROM JBPM4_HIST_PROCINST hpi
WHERE hpi.END_ IS NOT NULL
@@ -249,7 +230,7 @@
<design:name>PROCESS_DEFINITION</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
- <design:precision>2147483647</design:precision>
+ <design:precision>255</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
@@ -267,10 +248,10 @@
<design:attributes>
<design:name>AVERAGE_DURATION</design:name>
<design:position>2</design:position>
- <design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
- <design:precision>19</design:precision>
- <design:scale>0</design:scale>
- <design:nullability>NotNullable</design:nullability>
+ <design:nativeDataTypeCode>3</design:nativeDataTypeCode>
+ <design:precision>23</design:precision>
+ <design:scale>4</design:scale>
+ <design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>AVERAGE_DURATION</design:displayName>
</design:uiHints>
@@ -278,7 +259,7 @@
<design:usageHints>
<design:label>AVERAGE_DURATION</design:label>
<design:formattingHints>
- <design:displaySize>20</design:displaySize>
+ <design:displaySize>25</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
@@ -287,9 +268,9 @@
<design:name>STDDEV_DURATION</design:name>
<design:position>3</design:position>
<design:nativeDataTypeCode>8</design:nativeDataTypeCode>
- <design:precision>17</design:precision>
- <design:scale>0</design:scale>
- <design:nullability>NotNullable</design:nullability>
+ <design:precision>23</design:precision>
+ <design:scale>31</design:scale>
+ <design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>STDDEV_DURATION</design:displayName>
</design:uiHints>
@@ -456,6 +437,24 @@
<property name="marginTop">10pt</property>
<property name="marginLeft">10pt</property>
<property name="width">6.622222222222222in</property>
+ <property name="dataSet">proc_count</property>
+ <list-property name="boundDataColumns">
+ <structure>
+ <property
name="name">process_definition</property>
+ <expression
name="expression">dataSetRow["process_definition"]</expression>
+ <property name="dataType">string</property>
+ </structure>
+ <structure>
+ <property
name="name">total_nr_of_instances</property>
+ <expression
name="expression">dataSetRow["total_nr_of_instances"]</expression>
+ <property name="dataType">decimal</property>
+ </structure>
+ <structure>
+ <property
name="name">active_instances</property>
+ <expression
name="expression">dataSetRow["active_instances"]</expression>
+ <property name="dataType">decimal</property>
+ </structure>
+ </list-property>
<column id="354">
<property
name="width">2.811111111111111in</property>
</column>
@@ -470,12 +469,26 @@
</cell>
<cell id="358">
<data id="309">
- <property
name="dataSet">process_definition_counts</property>
+ <property
name="dataSet">proc_count</property>
<list-property name="boundDataColumns">
<structure>
+ <property
name="name">process_definition</property>
+ <expression
name="expression">dataSetRow["process_definition"]</expression>
+ <property
name="dataType">string</property>
+ </structure>
+ <structure>
+ <property
name="name">total_nr_of_instances</property>
+ <expression
name="expression">dataSetRow["total_nr_of_instances"]</expression>
+ <property
name="dataType">decimal</property>
+ </structure>
+ <structure>
+ <property
name="name">active_instances</property>
+ <expression
name="expression">dataSetRow["active_instances"]</expression>
+ <property
name="dataType">decimal</property>
+ </structure>
+ <structure>
<property name="name">Column
Binding</property>
<expression
name="expression">Total.count()</expression>
- <property
name="dataType">integer</property>
</structure>
</list-property>
<property name="resultSetColumn">Column
Binding</property>
@@ -490,30 +503,30 @@
</cell>
<cell id="361">
<data id="311">
- <property
name="dataSet">process_definition_counts</property>
+ <property
name="dataSet">proc_count</property>
<list-property name="boundDataColumns">
<structure>
- <property
name="name">PROCESS_DEFINITION</property>
- <expression
name="expression">dataSetRow["PROCESS_DEFINITION"]</expression>
+ <property
name="name">process_definition</property>
+ <expression
name="expression">dataSetRow["process_definition"]</expression>
<property
name="dataType">string</property>
</structure>
<structure>
- <property
name="name">TOTAL_NR_OF_INSTANCES</property>
- <expression
name="expression">dataSetRow["TOTAL_NR_OF_INSTANCES"]</expression>
- <property
name="dataType">integer</property>
+ <property
name="name">total_nr_of_instances</property>
+ <expression
name="expression">dataSetRow["total_nr_of_instances"]</expression>
+ <property
name="dataType">decimal</property>
</structure>
<structure>
- <property
name="name">ACTIVE_INSTANCES</property>
- <expression
name="expression">dataSetRow["ACTIVE_INSTANCES"]</expression>
- <property
name="dataType">integer</property>
+ <property
name="name">active_instances</property>
+ <expression
name="expression">dataSetRow["active_instances"]</expression>
+ <property
name="dataType">decimal</property>
</structure>
<structure>
- <property
name="name">total_nr_active_instances</property>
- <expression
name="expression">Total.sum(dataSetRow["ACTIVE_INSTANCES"])</expression>
+ <property name="name">Column
Binding</property>
+ <expression
name="expression">Total.sum(dataSetRow["active_instances"])</expression>
<property
name="dataType">integer</property>
</structure>
</list-property>
- <property
name="resultSetColumn">total_nr_active_instances</property>
+ <property name="resultSetColumn">Column
Binding</property>
</data>
</cell>
</row>
@@ -525,30 +538,30 @@
</cell>
<cell id="364">
<data id="310">
- <property
name="dataSet">process_definition_counts</property>
+ <property
name="dataSet">proc_count</property>
<list-property name="boundDataColumns">
<structure>
- <property
name="name">PROCESS_DEFINITION</property>
- <expression
name="expression">dataSetRow["PROCESS_DEFINITION"]</expression>
+ <property
name="name">process_definition</property>
+ <expression
name="expression">dataSetRow["process_definition"]</expression>
<property
name="dataType">string</property>
</structure>
<structure>
- <property
name="name">TOTAL_NR_OF_INSTANCES</property>
- <expression
name="expression">dataSetRow["TOTAL_NR_OF_INSTANCES"]</expression>
- <property
name="dataType">integer</property>
+ <property
name="name">total_nr_of_instances</property>
+ <expression
name="expression">dataSetRow["total_nr_of_instances"]</expression>
+ <property
name="dataType">decimal</property>
</structure>
<structure>
- <property
name="name">ACTIVE_INSTANCES</property>
- <expression
name="expression">dataSetRow["ACTIVE_INSTANCES"]</expression>
- <property
name="dataType">integer</property>
+ <property
name="name">active_instances</property>
+ <expression
name="expression">dataSetRow["active_instances"]</expression>
+ <property
name="dataType">decimal</property>
</structure>
<structure>
- <property
name="name">total_nr_instances</property>
- <expression
name="expression">Total.sum(dataSetRow["TOTAL_NR_OF_INSTANCES"])</expression>
+ <property name="name">Column
Binding</property>
+ <expression
name="expression">Total.sum(dataSetRow["total_nr_of_instances"])</expression>
<property
name="dataType">integer</property>
</structure>
</list-property>
- <property
name="resultSetColumn">total_nr_instances</property>
+ <property name="resultSetColumn">Column
Binding</property>
</data>
</cell>
</row>
@@ -570,23 +583,35 @@
<property name="marginBottom">0px</property>
<property name="marginRight">0px</property>
<property name="width">5.355555555555555in</property>
- <property
name="dataSet">process_definition_counts</property>
+ <property name="dataSet">proc_count</property>
<list-property name="boundDataColumns">
<structure>
- <property
name="name">PROCESS_DEFINITION</property>
- <expression
name="expression">dataSetRow["PROCESS_DEFINITION"]</expression>
+ <property
name="name">process_definition</property>
+ <expression
name="expression">dataSetRow["process_definition"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
- <property
name="name">TOTAL_NR_OF_INSTANCES</property>
- <expression
name="expression">dataSetRow["TOTAL_NR_OF_INSTANCES"]</expression>
- <property name="dataType">integer</property>
+ <property
name="name">total_nr_of_instances</property>
+ <expression
name="expression">dataSetRow["total_nr_of_instances"]</expression>
+ <property name="dataType">decimal</property>
</structure>
<structure>
- <property
name="name">ACTIVE_INSTANCES</property>
- <expression
name="expression">dataSetRow["ACTIVE_INSTANCES"]</expression>
- <property name="dataType">integer</property>
+ <property
name="name">active_instances</property>
+ <expression
name="expression">dataSetRow["active_instances"]</expression>
+ <property name="dataType">decimal</property>
</structure>
+ <structure>
+ <property name="name">Column
Binding</property>
+ <expression
name="expression">dataSetRow["process_definition"]</expression>
+ </structure>
+ <structure>
+ <property name="name">Column
Binding_1</property>
+ <expression
name="expression">dataSetRow["total_nr_of_instances"]</expression>
+ </structure>
+ <structure>
+ <property name="name">Column
Binding_2</property>
+ <expression
name="expression">dataSetRow["active_instances"]</expression>
+ </structure>
</list-property>
<column id="300">
<property
name="width">1.9666666666666666in</property>
@@ -620,19 +645,19 @@
<row id="292">
<cell id="293">
<data id="303">
- <property
name="resultSetColumn">PROCESS_DEFINITION</property>
+ <property name="resultSetColumn">Column
Binding</property>
</data>
</cell>
<cell id="294">
<data id="304">
<property
name="textAlign">center</property>
- <property
name="resultSetColumn">TOTAL_NR_OF_INSTANCES</property>
+ <property name="resultSetColumn">Column
Binding_1</property>
</data>
</cell>
<cell id="295">
<data id="305">
<property
name="textAlign">center</property>
- <property
name="resultSetColumn">ACTIVE_INSTANCES</property>
+ <property name="resultSetColumn">Column
Binding_2</property>
</data>
</cell>
</row>
@@ -1351,7 +1376,7 @@
<Visible>true</Visible>
</Label>
<DataDefinition>
-
<Definition>row["TOTAL_NR_OF_INSTANCES"]</Definition>
+
<Definition>row["total_nr_of_instances"]</Definition>
</DataDefinition>
<SeriesIdentifier></SeriesIdentifier>
<DataPoint>
@@ -1454,7 +1479,7 @@
<Visible>false</Visible>
</Label>
<DataDefinition>
- <Definition>row["PROCESS_DEFINITION"]</Definition>
+ <Definition>row["process_definition"]</Definition>
</DataDefinition>
<SeriesIdentifier></SeriesIdentifier>
<DataPoint>
@@ -1476,24 +1501,24 @@
</model:ChartWithoutAxes>
]]></xml-property>
<property name="outputFormat">SVG</property>
- <property
name="dataSet">process_definition_counts</property>
+ <property name="dataSet">proc_count</property>
<property name="height">3.9in</property>
<property name="width">7.777777777777778in</property>
<list-property name="boundDataColumns">
<structure>
- <property
name="name">PROCESS_DEFINITION</property>
- <expression
name="expression">dataSetRow["PROCESS_DEFINITION"]</expression>
+ <property
name="name">process_definition</property>
+ <expression
name="expression">dataSetRow["process_definition"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
- <property
name="name">TOTAL_NR_OF_INSTANCES</property>
- <expression
name="expression">dataSetRow["TOTAL_NR_OF_INSTANCES"]</expression>
- <property name="dataType">integer</property>
+ <property
name="name">total_nr_of_instances</property>
+ <expression
name="expression">dataSetRow["total_nr_of_instances"]</expression>
+ <property name="dataType">decimal</property>
</structure>
<structure>
- <property
name="name">ACTIVE_INSTANCES</property>
- <expression
name="expression">dataSetRow["ACTIVE_INSTANCES"]</expression>
- <property name="dataType">integer</property>
+ <property
name="name">active_instances</property>
+ <expression
name="expression">dataSetRow["active_instances"]</expression>
+ <property name="dataType">decimal</property>
</structure>
</list-property>
</extended-item>
@@ -2837,7 +2862,7 @@
</model:ChartWithAxes>
]]></xml-property>
<property name="outputFormat">SVG</property>
- <property
name="dataSet">process_performance</property>
+ <property name="dataSet">proc_perf</property>
<property
name="height">4.2444444444444445in</property>
<property name="width">7.788888888888889in</property>
<list-property name="boundDataColumns">