=== 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-05-20 08:41:33 +0000
+++ dhis-2/dhis-services/dhis-service-patient/src/main/java/org/hisp/dhis/caseaggregation/jdbc/JdbcCaseAggregationConditionManager.java	2013-05-22 14:56:12 +0000
@@ -315,11 +315,11 @@
             {
                 if ( operator.equals( CaseAggregationCondition.AGGRERATION_COUNT ) )
                 {
-                    sql += operator + " (distinct(pi.patientid) ) as value ";
+                    sql += " count (distinct(pi.patientid) ) as value ";
                 }
                 else
                 {
-                    sql += operator + " (distinct(psi.programinstanceid ) ) as value ";
+                    sql += " count (psi.programinstanceid ) as value ";
                 }
 
                 sql += "FROM programstageinstance as psi ";
@@ -540,14 +540,14 @@
 
             sql = "select periodid from period where periodtypeid=" + periodTypeId + " and startdate='" + start
                 + "' and enddate='" + end + "'";
-            int periodid = 0;
+            Integer periodid = null;
             SqlRowSet rs = jdbcTemplate.queryForRowSet( sql );
             if ( rs.next() )
             {
                 periodid = rs.getInt( "periodid" );
             }
 
-            if ( periodid == 0 )
+            if ( periodid == null)
             {
                 String insertSql = "insert into period (periodtypeid,startdate,enddate) " + " VALUES " + "("
                     + periodTypeId + ",'" + start + "','" + end + "' )";

=== modified file 'dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-patient/src/main/resources/org/hisp/dhis/patient/i18n_module.properties'
--- dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-patient/src/main/resources/org/hisp/dhis/patient/i18n_module.properties	2013-05-21 10:43:35 +0000
+++ dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-patient/src/main/resources/org/hisp/dhis/patient/i18n_module.properties	2013-05-22 14:56:12 +0000
@@ -405,4 +405,5 @@
 filter_by_type = Filter by type
 orgunit_group = Organisation unit group
 enrollement_date = Enrollement date
-days_since_incident_date = Days since incident date
\ No newline at end of file
+days_since_incident_date = Days since incident date
+view_all = View all
\ No newline at end of file