=== modified file 'dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/trackedentity/hibernate/HibernateTrackedEntityInstanceStore.java' --- dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/trackedentity/hibernate/HibernateTrackedEntityInstanceStore.java 2015-09-22 04:27:04 +0000 +++ dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/trackedentity/hibernate/HibernateTrackedEntityInstanceStore.java 2015-09-23 17:18:09 +0000 @@ -189,7 +189,7 @@ if ( params.hasProgram() ) { hql += hlp.whereAnd() + "exists (from ProgramInstance pi where pi.entityInstance=tei"; - hql += hlp.whereAnd() + "pi.program.uid = '" + params.getProgram().getUid() + "'"; + hql += " and pi.program.uid = '" + params.getProgram().getUid() + "'"; if ( params.hasProgramStatus() ) {