=== modified file 'dhis-2/dhis-services/dhis-service-patient/src/main/java/org/hisp/dhis/caseaggregation/jdbc/JdbcCaseAggregationConditionManager.java' --- dhis-2/dhis-services/dhis-service-patient/src/main/java/org/hisp/dhis/caseaggregation/jdbc/JdbcCaseAggregationConditionManager.java 2013-06-14 04:17:29 +0000 +++ dhis-2/dhis-services/dhis-service-patient/src/main/java/org/hisp/dhis/caseaggregation/jdbc/JdbcCaseAggregationConditionManager.java 2013-06-14 04:23:19 +0000 @@ -377,6 +377,8 @@ @Override public String parseExpressionDetailsToSql( String caseExpression, String operator, Integer orgunitId, Period period ) { + caseExpression = formatExpression( caseExpression ); + String sql = "SELECT "; boolean hasPatients = hasPatientCriteria( caseExpression );