=== modified file 'dhis-2/dhis-api/src/main/java/org/hisp/dhis/trackedentity/TrackedEntityInstanceQueryParams.java' --- dhis-2/dhis-api/src/main/java/org/hisp/dhis/trackedentity/TrackedEntityInstanceQueryParams.java 2015-12-23 12:56:31 +0000 +++ dhis-2/dhis-api/src/main/java/org/hisp/dhis/trackedentity/TrackedEntityInstanceQueryParams.java 2015-12-28 13:08:12 +0000 @@ -55,6 +55,7 @@ public static final String CREATED_ID = "created"; public static final String LAST_UPDATED_ID = "lastupdated"; public static final String ORG_UNIT_ID = "ou"; + public static final String ORG_UNIT_NAME = "ouname"; public static final String TRACKED_ENTITY_ID = "te"; public static final String TRACKED_ENTITY_ATTRIBUTE_ID = "teattribute"; public static final String TRACKED_ENTITY_ATTRIBUTE_VALUE_ID = "tevalue"; === modified file 'dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/trackedentity/DefaultTrackedEntityInstanceService.java' --- dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/trackedentity/DefaultTrackedEntityInstanceService.java 2015-12-23 12:56:31 +0000 +++ dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/trackedentity/DefaultTrackedEntityInstanceService.java 2015-12-28 13:08:12 +0000 @@ -176,7 +176,8 @@ grid.addHeader( new GridHeader( TRACKED_ENTITY_INSTANCE_ID, "Instance" ) ); grid.addHeader( new GridHeader( CREATED_ID, "Created" ) ); grid.addHeader( new GridHeader( LAST_UPDATED_ID, "Last updated" ) ); - grid.addHeader( new GridHeader( ORG_UNIT_ID, "Org unit" ) ); + grid.addHeader( new GridHeader( ORG_UNIT_ID, "Organisation unit" ) ); + grid.addHeader( new GridHeader( ORG_UNIT_NAME, "Organisation unit name" ) ); grid.addHeader( new GridHeader( TRACKED_ENTITY_ID, "Tracked entity" ) ); grid.addHeader( new GridHeader( INACTIVE_ID, "Inactive" ) ); @@ -200,6 +201,7 @@ grid.addValue( entity.get( CREATED_ID ) ); grid.addValue( entity.get( LAST_UPDATED_ID ) ); grid.addValue( entity.get( ORG_UNIT_ID ) ); + grid.addValue( entity.get( ORG_UNIT_NAME ) ); grid.addValue( entity.get( TRACKED_ENTITY_ID ) ); grid.addValue( entity.get( INACTIVE_ID ) ); === 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-12-23 12:56:31 +0000 +++ dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/trackedentity/hibernate/HibernateTrackedEntityInstanceStore.java 2015-12-28 13:08:12 +0000 @@ -219,9 +219,14 @@ // Select clause // --------------------------------------------------------------------- - String sql = "select tei.uid as " + TRACKED_ENTITY_INSTANCE_ID + ", " + "tei.created as " + CREATED_ID + ", " - + "tei.lastupdated as " + LAST_UPDATED_ID + ", " + "ou.uid as " + ORG_UNIT_ID + ", " + "te.uid as " - + TRACKED_ENTITY_ID + ", " + "tei.inactive as " + INACTIVE_ID + ", "; + String sql = + "select tei.uid as " + TRACKED_ENTITY_INSTANCE_ID + ", " + + "tei.created as " + CREATED_ID + ", " + + "tei.lastupdated as " + LAST_UPDATED_ID + ", " + + "ou.uid as " + ORG_UNIT_ID + ", " + + "ou.name as " + ORG_UNIT_NAME + ", " + + "te.uid as " + TRACKED_ENTITY_ID + ", " + + "tei.inactive as " + INACTIVE_ID + ", "; for ( QueryItem item : params.getAttributes() ) { @@ -265,6 +270,7 @@ map.put( CREATED_ID, rowSet.getString( CREATED_ID ) ); map.put( LAST_UPDATED_ID, rowSet.getString( LAST_UPDATED_ID ) ); map.put( ORG_UNIT_ID, rowSet.getString( ORG_UNIT_ID ) ); + map.put( ORG_UNIT_NAME, rowSet.getString( ORG_UNIT_NAME ) ); map.put( TRACKED_ENTITY_ID, rowSet.getString( TRACKED_ENTITY_ID ) ); map.put( INACTIVE_ID, rowSet.getString( INACTIVE_ID ) );