=== modified file 'dhis-2/dhis-services/dhis-service-patient/src/main/java/org/hisp/dhis/program/hibernate/HibernateProgramStageInstanceStore.java' --- dhis-2/dhis-services/dhis-service-patient/src/main/java/org/hisp/dhis/program/hibernate/HibernateProgramStageInstanceStore.java 2012-10-16 08:33:54 +0000 +++ dhis-2/dhis-services/dhis-service-patient/src/main/java/org/hisp/dhis/program/hibernate/HibernateProgramStageInstanceStore.java 2012-10-16 09:52:43 +0000 @@ -207,13 +207,21 @@ for ( int i = level; i <= maxLevel; i++ ) { String name = orgUnitLevelMap.containsKey( i ) ? orgUnitLevelMap.get( i ).getName() : "Level " + i; - grid.addHeader( new GridHeader( name, false, true ) ); } + Collection deKeys = new HashSet(); for ( TabularReportColumn column : columns ) { - grid.addHeader( new GridHeader( column.getName(), column.isHidden(), true ) ); + if ( !column.isMeta() ) + { + String deKey = "element_" + column.getIdentifier(); + if ( !deKeys.contains( deKey ) ) + { + grid.addHeader( new GridHeader( column.getName(), column.isHidden(), true ) ); + deKeys.add( deKey ); + } + } } // --------------------------------------------------------------------- @@ -398,7 +406,7 @@ + column.getIdentifier() + ") as element_" + column.getIdentifier() + ","; deKeys.add( deKey ); } - + if ( column.hasQuery() ) { where += operator + "element_" + column.getIdentifier() + " " + column.getQuery() + " "; @@ -414,7 +422,7 @@ + column.getIdentifier() + ") as element_" + column.getIdentifier() + ","; deKeys.add( deKey ); } - + if ( column.hasQuery() ) { where += operator + "lower(element_" + column.getIdentifier() + ") " + column.getQuery() + " "; @@ -460,7 +468,7 @@ sql += where; // filters sql = sql.substring( 0, sql.length() - 1 ) + " "; // Remove last comma sql += (min != null && max != null) ? statementBuilder.limitRecord( min, max ) : ""; - + return sql; } } === modified file 'dhis-2/dhis-web/dhis-web-caseentry/src/main/webapp/dhis-web-caseentry/app/app.js' --- dhis-2/dhis-web/dhis-web-caseentry/src/main/webapp/dhis-web-caseentry/app/app.js 2012-10-16 08:33:54 +0000 +++ dhis-2/dhis-web/dhis-web-caseentry/src/main/webapp/dhis-web-caseentry/app/app.js 2012-10-16 09:52:43 +0000 @@ -752,14 +752,11 @@ // Get fields var fields = []; fields[0] = 'id'; - var record = new Array(); for( var index=1; index < TR.value.columns.length; index++ ) { fields[index] = 'col' + index; - record.push(''); } TR.value.fields = fields; - TR.value.values.unshift(record); // Set data for grid TR.store.getDataTableStore(); @@ -790,7 +787,6 @@ TR.util.notification.ok(); }, filterReport: function() { - TR.state.getFilterValues(); TR.util.mask.showMask(TR.cmp.region.center, TR.i18n.loading); var url = TR.conf.finals.ajax.path_root + TR.conf.finals.ajax.generatetabularreport_get; Ext.Ajax.request({ @@ -801,12 +797,6 @@ success: function(r) { var json = Ext.JSON.decode(r.responseText); TR.value.values = json.items; - var record = new Array(); - for( var index=1; index < TR.value.columns.length; index++ ){ - record.push(''); - } - TR.value.values.unshift(record); - TR.store.datatable.loadData(TR.value.values,false); if ( json.items.length > 1 ) { @@ -830,27 +820,6 @@ } }) }, - getFilterValues: function() - { - var grid = TR.datatable.datatable; - - var filters = grid.filters.getFilterData(); - var value = ""; - for( var i=0; i