=== 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-10-07 13:22:46 +0000 +++ dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/trackedentity/hibernate/HibernateTrackedEntityInstanceStore.java 2015-10-09 03:21:10 +0000 @@ -121,7 +121,7 @@ private String buildTrackedEntityInstanceHql( TrackedEntityInstanceQueryParams params ) { - String hql = "from TrackedEntityInstance tei inner join fetch tei.attributeValues"; + String hql = "select distinct tei from TrackedEntityInstance tei inner join fetch tei.attributeValues"; SqlHelper hlp = new SqlHelper( true ); if ( params.hasTrackedEntity() )