=== 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-02-18 09:39:18 +0000 +++ dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcAnalyticsTableManager.java 2014-02-21 14:30:01 +0000 @@ -140,6 +140,8 @@ return null; } + // TODO join categoryoptiongroupsetstructure on both categoryoptioncomboid and attributeoptioncomboid + private void populateTable( AnalyticsTable table, String valueExpression, String valueType, String clause ) { final String start = DateUtils.getMediumDateString( table.getPeriod().getStartDate() ); @@ -166,7 +168,7 @@ "from datavalue dv " + "left join _dataelementgroupsetstructure degs on dv.dataelementid=degs.dataelementid " + "left join _organisationunitgroupsetstructure ougs on dv.sourceid=ougs.organisationunitid " + - "left join _categoryoptiongroupsetstructure cogs on dv.categoryoptioncomboid=cogs.categoryoptioncomboid " + + "left join _categoryoptiongroupsetstructure cogs on dv.attributeoptioncomboid=cogs.categoryoptioncomboid " + "left join _categorystructure dcs on dv.categoryoptioncomboid=dcs.categoryoptioncomboid " + "left join _categorystructure acs on dv.attributeoptioncomboid=acs.categoryoptioncomboid " + "left join _orgunitstructure ous on dv.sourceid=ous.organisationunitid " +