=== modified file 'dhis-2/dhis-services/dhis-service-dxf2/src/main/java/org/hisp/dhis/dxf2/events/event/JdbcEventStore.java' --- dhis-2/dhis-services/dhis-service-dxf2/src/main/java/org/hisp/dhis/dxf2/events/event/JdbcEventStore.java 2014-06-20 14:17:48 +0000 +++ dhis-2/dhis-services/dhis-service-dxf2/src/main/java/org/hisp/dhis/dxf2/events/event/JdbcEventStore.java 2014-06-24 14:23:58 +0000 @@ -265,23 +265,23 @@ if ( status == EventStatus.VISITED ) { - sql = "and psi.status = " + + EventStatus.ACTIVE.getValue() + " and psi.executiondate is not null "; + sql = "and psi.status = '" + EventStatus.ACTIVE.name() + "' and psi.executiondate is not null "; } else if ( status == EventStatus.COMPLETED ) { - sql = "and psi.status = " + EventStatus.COMPLETED.getValue(); + sql = "and psi.status = '" + EventStatus.COMPLETED.name() + "' "; } else if ( status == EventStatus.SCHEDULE ) { - sql += "and psi.executiondate is null and date(now()) <= date(psi.duedate) and psi.status = 0 "; + sql += "and psi.executiondate is null and date(now()) <= date(psi.duedate) and psi.status = '" + EventStatus.ACTIVE.name() + "' "; } else if ( status == EventStatus.OVERDUE ) { - sql += "and psi.executiondate is null and date(now()) > date(psi.duedate) and psi.status = 0 "; + sql += "and psi.executiondate is null and date(now()) > date(psi.duedate) and psi.status = '" + EventStatus.ACTIVE.name() + "' "; } else { - sql += "and psi.status = " + status.getValue() + " "; + sql += "and psi.status = '" + status.name() + "' "; } } === modified file 'dhis-2/dhis-services/dhis-service-tracker/src/main/java/org/hisp/dhis/program/hibernate/HibernateProgramStageInstanceStore.java' --- dhis-2/dhis-services/dhis-service-tracker/src/main/java/org/hisp/dhis/program/hibernate/HibernateProgramStageInstanceStore.java 2014-06-20 12:32:01 +0000 +++ dhis-2/dhis-services/dhis-service-tracker/src/main/java/org/hisp/dhis/program/hibernate/HibernateProgramStageInstanceStore.java 2014-06-24 14:23:58 +0000 @@ -213,7 +213,7 @@ + "and pg.programid = " + program.getId() + "group by ou.name, ps.name, psi.completeduser, psi.completeddate, psi.status " + "having psi.completeddate >= '" + startDate + "' AND psi.completeddate <= '" + endDate + "' " - + "and psi.status=" + EventStatus.COMPLETED.getValue() + + "and psi.status='" + EventStatus.COMPLETED.name() + "' " + "order by ou.name, ps.name, psi.completeduser"; SqlRowSet rs = jdbcTemplate.queryForRowSet( sql ); === modified file 'dhis-2/dhis-services/dhis-service-tracker/src/main/java/org/hisp/dhis/trackedentity/hibernate/HibernateTrackedEntityInstanceStore.java' --- dhis-2/dhis-services/dhis-service-tracker/src/main/java/org/hisp/dhis/trackedentity/hibernate/HibernateTrackedEntityInstanceStore.java 2014-06-20 12:32:01 +0000 +++ dhis-2/dhis-services/dhis-service-tracker/src/main/java/org/hisp/dhis/trackedentity/hibernate/HibernateTrackedEntityInstanceStore.java 2014-06-24 14:23:58 +0000 @@ -365,13 +365,13 @@ { sql = "and psi.executiondate >= '" + start + "' and psi.executiondate <= '" + end + "' " + - "and psi.status = " + EventStatus.COMPLETED.getValue() ; + "and psi.status = '" + EventStatus.COMPLETED.name() + "' "; } else if ( params.isEventStatus( EventStatus.VISITED ) ) { sql = "and psi.executiondate >= '" + start + "' and psi.executiondate <= '" + end + "' " + - "and psi.status = " + EventStatus.ACTIVE.getValue() ; + "and psi.status = '" + EventStatus.ACTIVE.name() + "' "; } else if ( params.isEventStatus( EventStatus.SCHEDULE ) ) { @@ -389,7 +389,7 @@ { sql = "and psi.duedate >= '" + start + "' and psi.duedate <= '" + end + "' " + - "and psi.status = " + EventStatus.SKIPPED.getValue() + " "; + "and psi.status = '" + EventStatus.SKIPPED.name() + "' "; } return sql; === modified file 'dhis-2/dhis-web/dhis-web-caseentry/src/main/webapp/dhis-web-caseentry/activityPlanSelect.vm' --- dhis-2/dhis-web/dhis-web-caseentry/src/main/webapp/dhis-web-caseentry/activityPlanSelect.vm 2014-04-24 16:30:48 +0000 +++ dhis-2/dhis-web/dhis-web-caseentry/src/main/webapp/dhis-web-caseentry/activityPlanSelect.vm 2014-06-24 14:23:58 +0000 @@ -67,8 +67,8 @@ - + - +