[jbpm-commits] JBoss JBPM SVN: r5604 - jbpm4/trunk/modules/integration/report/src/main/resources.

Author: jbarrez Date: 2009-08-31 09:00:36 -0400 (Mon, 31 Aug 2009) New Revision: 5604 Modified: jbpm4/trunk/modules/integration/report/src/main/resources/overall_activity.rptdesign Log: Fix for JBPM-2512: overall_activity.rptdesign doesn't work on Mysql Modified: jbpm4/trunk/modules/integration/report/src/main/resources/overall_activity.rptdesign =================================================================== --- jbpm4/trunk/modules/integration/report/src/main/resources/overall_activity.rptdesign 2009-08-31 12:49:59 UTC (rev 5603) +++ jbpm4/trunk/modules/integration/report/src/main/resources/overall_activity.rptdesign 2009-08-31 13:00:36 UTC (rev 5604) @@ -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 &lt;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[&quot;TOTAL_NR_OF_INSTANCES&quot;]</Definition> + <Definition>row[&quot;total_nr_of_instances&quot;]</Definition> </DataDefinition> <SeriesIdentifier></SeriesIdentifier> <DataPoint> @@ -1454,7 +1479,7 @@ <Visible>false</Visible> </Label> <DataDefinition> - <Definition>row[&quot;PROCESS_DEFINITION&quot;]</Definition> + <Definition>row[&quot;process_definition&quot;]</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">