=== modified file 'dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcAnalyticsTableManager.java' --- dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcAnalyticsTableManager.java 2014-06-16 19:51:38 +0000 +++ dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcAnalyticsTableManager.java 2014-06-17 10:52:38 +0000 @@ -193,7 +193,7 @@ "left join categoryoptioncombo co on dv.categoryoptioncomboid=co.categoryoptioncomboid " + "left join period pe on dv.periodid=pe.periodid " + "where de.valuetype = '" + valueType + "' " + - "and de.domaintype = 'aggregate' " + + "and de.domaintype = 'AGGREGATE' " + "and pe.startdate >= '" + start + "' " + "and pe.startdate <= '" + end + "' " + "and dv.value is not null " +