=== modified file 'dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcEventAnalyticsTableManager.java' --- dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcEventAnalyticsTableManager.java 2015-09-17 14:51:08 +0000 +++ dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcEventAnalyticsTableManager.java 2015-09-21 11:22:28 +0000 @@ -318,6 +318,7 @@ String[] pi = { quote( "pi" ), "character(11) not null", "pi.uid" }; String[] ps = { quote( "ps" ), "character(11) not null", "ps.uid" }; String[] erd = { quote( "enrollmentdate" ), "timestamp", "pi.enrollmentdate" }; + String[] idd = { quote( "incidentdate" ), "timestamp", "pi.incidentdate" }; String[] ed = { quote( "executiondate" ), "timestamp", "psi.executiondate" }; String[] dd = { quote( "duedate" ), "timestamp", "psi.duedate" }; String[] cd = { quote( "completeddate" ), "timestamp", "psi.completeddate" }; @@ -327,7 +328,7 @@ String[] oun = { quote( "ouname" ), "character varying(230) not null", "ou.name" }; String[] ouc = { quote( "oucode" ), "character varying(50)", "ou.code" }; - columns.addAll( Lists.newArrayList( psi, pi, ps, erd, ed, dd, cd, longitude, latitude, ou, oun, ouc ) ); + columns.addAll( Lists.newArrayList( psi, pi, ps, erd, idd, ed, dd, cd, longitude, latitude, ou, oun, ouc ) ); if ( table.hasProgram() && table.getProgram().isRegistration() ) { === modified file 'dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/program/DefaultProgramIndicatorService.java' --- dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/program/DefaultProgramIndicatorService.java 2015-09-18 12:51:09 +0000 +++ dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/program/DefaultProgramIndicatorService.java 2015-09-21 11:22:28 +0000 @@ -747,6 +747,10 @@ { return "enrollmentdate"; } + else if ( ProgramIndicator.VAR_INCIDENT_DATE.equals( var ) ) + { + return "incidentdate"; + } else if ( ProgramIndicator.VAR_CURRENT_DATE.equals( var ) ) { return "'" + DateUtils.getLongDateString() + "'";