=== modified file 'dhis-2/dhis-services/dhis-service-patient/src/main/java/org/hisp/dhis/caseaggregation/DefaultCaseAggregationConditionService.java' --- dhis-2/dhis-services/dhis-service-patient/src/main/java/org/hisp/dhis/caseaggregation/DefaultCaseAggregationConditionService.java 2012-11-12 04:55:25 +0000 +++ dhis-2/dhis-services/dhis-service-patient/src/main/java/org/hisp/dhis/caseaggregation/DefaultCaseAggregationConditionService.java 2012-11-12 05:15:33 +0000 @@ -226,7 +226,7 @@ Period period ) { String sql = convertCondition( aggregationCondition, orgunit, period ); -System.out.println("\n\n === \n SQL : \n" + sql ); + Collection patientIds = aggregationConditionStore.executeSQL( sql ); if ( patientIds == null ) @@ -847,7 +847,7 @@ if ( propertyName.equals( PROPERTY_AGE ) ) { - sql += "DATE('" + startDate + "') - DATE(birthdate) "; + sql += "DATE(registrationdate) - DATE(birthdate) "; } else { === modified file 'dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-patient/src/main/webapp/dhis-web-maintenance-patient/caseAggregationForm.vm' --- dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-patient/src/main/webapp/dhis-web-maintenance-patient/caseAggregationForm.vm 2012-11-12 04:55:25 +0000 +++ dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-patient/src/main/webapp/dhis-web-maintenance-patient/caseAggregationForm.vm 2012-11-12 05:15:33 +0000 @@ -47,7 +47,7 @@ - +