Author: heiko.braun(a)jboss.com Date: 2009-05-30 13:04:56 -0400 (Sat, 30 May 2009) New Revision: 4952 Modified: jbpm4/trunk/modules/integration/report/src/main/resources/overall_activity.rptdesign jbpm4/trunk/modules/integration/report/src/main/resources/process_summary.rptdesign Log: Fix report SQL on HSQLDB Modified: jbpm4/trunk/modules/integration/report/src/main/resources/overall_activity.rptdesign =================================================================== --- jbpm4/trunk/modules/integration/report/src/main/resources/overall_activity.rptdesign 2009-05-30 15:36:05 UTC (rev 4951) +++ jbpm4/trunk/modules/integration/report/src/main/resources/overall_activity.rptdesign 2009-05-30 17:04:56 UTC (rev 4952) @@ -74,10 +74,10 @@ </structure> </list-property> <property name="queryText">SELECT d.DBID_ as dpl, p.STRINGVAL_ as processId FROM JBPM4_DEPLOYMENT d, JBPM4_DEPLOYPROP p - WHERE p.KEY_='pdid' - AND d.DBID_=p.DEPLOYMENT_ - GROUP BY dpl - LIMIT 10</property> + WHERE p.KEY_='pdid' + AND d.DBID_=p.DEPLOYMENT_ + GROUP BY dpl,processId + LIMIT 10</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> Modified: jbpm4/trunk/modules/integration/report/src/main/resources/process_summary.rptdesign =================================================================== --- jbpm4/trunk/modules/integration/report/src/main/resources/process_summary.rptdesign 2009-05-30 15:36:05 UTC (rev 4951) +++ jbpm4/trunk/modules/integration/report/src/main/resources/process_summary.rptdesign 2009-05-30 17:04:56 UTC (rev 4952) @@ -211,7 +211,7 @@ <property name="queryText">select * FROM JBPM4_HIST_PROCINST J WHERE PROCDEFID_= ? - AND STATE_ LIKE "active"</property> + AND STATE_ LIKE 'active'</property> </oda-data-set> <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="total_instances" id="147"> <list-property name="computedColumns"> @@ -558,8 +558,8 @@ </list-property> <property name="queryText">SELECT ID_ as instanceId, DURATION_ FROM JBPM4_HIST_PROCINST J - WHERE PROCDEFID_= ? - and STATE_ NOT LIKE "active" + WHERE PROCDEFID_= ? + and STATE_ NOT LIKE 'active' ORDER BY DURATION_ DESC</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...