=== modified file 'dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/event/data/DefaultEventAnalyticsService.java' --- dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/event/data/DefaultEventAnalyticsService.java 2013-09-27 20:35:13 +0000 +++ dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/event/data/DefaultEventAnalyticsService.java 2013-09-28 11:32:11 +0000 @@ -164,6 +164,7 @@ grid.addHeader( new GridHeader( ITEM_EXECUTION_DATE, "Execution date" ) ); grid.addHeader( new GridHeader( ITEM_ORG_UNIT, "Organisation unit" ) ); grid.addHeader( new GridHeader( ITEM_ORG_UNIT_NAME, "Organisation unit name" ) ); + grid.addHeader( new GridHeader( ITEM_ORG_UNIT_NAME, "Organisation unit code" ) ); for ( QueryItem queryItem : params.getItems() ) { === modified file 'dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/event/data/JdbcEventAnalyticsManager.java' --- dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/event/data/JdbcEventAnalyticsManager.java 2013-09-27 20:35:13 +0000 +++ dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/event/data/JdbcEventAnalyticsManager.java 2013-09-28 11:32:11 +0000 @@ -114,7 +114,7 @@ public Grid getEvents( EventQueryParams params, Grid grid ) { - String sql = "select psi,ps,executiondate,ou,ouname" + getItemColumns( params ) + " "; + String sql = "select psi,ps,executiondate,ou,ouname,oucode" + getItemColumns( params ) + " "; // --------------------------------------------------------------------- // Criteria === 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 2013-09-27 11:13:20 +0000 +++ dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcEventAnalyticsTableManager.java 2013-09-28 11:32:11 +0000 @@ -230,9 +230,10 @@ String[] ps = { "ps", "character(11) not null", "ps.uid" }; String[] ed = { "executiondate", "date", "psi.executiondate" }; String[] ou = { "ou", "character(11) not null", "ou.uid" }; - String[] oun = { "ouname", "character varying(160) not null", "ou.name" }; + String[] oun = { "ouname", "character varying(230) not null", "ou.name" }; + String[] ouc = { "oucode", "character varying(50) not null", "ou.code" }; - columns.addAll( Arrays.asList( gender, isdead, psi, ps, ed, ou, oun ) ); + columns.addAll( Arrays.asList( gender, isdead, psi, ps, ed, ou, oun, ouc ) ); return columns; } === modified file 'dhis-2/dhis-web/dhis-web-api/src/main/java/org/hisp/dhis/api/controller/ResourceTableController.java' --- dhis-2/dhis-web/dhis-web-api/src/main/java/org/hisp/dhis/api/controller/ResourceTableController.java 2013-09-24 07:41:09 +0000 +++ dhis-2/dhis-web/dhis-web-api/src/main/java/org/hisp/dhis/api/controller/ResourceTableController.java 2013-09-28 11:32:11 +0000 @@ -84,7 +84,7 @@ @RequestMapping( value = "/dataMart", method = { RequestMethod.PUT, RequestMethod.POST } ) @PreAuthorize( "hasRole('ALL') or hasRole('F_DATA_MART_ADMIN')" ) - public void data( HttpServletResponse response ) + public void dataMart( HttpServletResponse response ) { dataMartTask.setTaskId( new TaskId( TaskCategory.DATAMART, currentUserService.getCurrentUser() ) );