=== modified file 'dhis-2/dhis-api/src/main/java/org/hisp/dhis/completeness/DataSetCompletenessStore.java' --- dhis-2/dhis-api/src/main/java/org/hisp/dhis/completeness/DataSetCompletenessStore.java 2012-03-16 16:49:58 +0000 +++ dhis-2/dhis-api/src/main/java/org/hisp/dhis/completeness/DataSetCompletenessStore.java 2012-07-20 08:57:31 +0000 @@ -47,8 +47,6 @@ Integer getCompulsoryDataElementRegistrations( DataSet dataSet, Collection children, Collection periods, int completenessOffset ); - Integer getNumberOfValues( DataSet dataSet, Collection children, Collection periods ); - Collection getDataSetsWithRegistrations( Collection dataSets ); /** === modified file 'dhis-2/dhis-services/dhis-service-reporting/src/main/java/org/hisp/dhis/completeness/jdbc/JDBCDataSetCompletenessStore.java' --- dhis-2/dhis-services/dhis-service-reporting/src/main/java/org/hisp/dhis/completeness/jdbc/JDBCDataSetCompletenessStore.java 2012-03-16 18:28:34 +0000 +++ dhis-2/dhis-services/dhis-service-reporting/src/main/java/org/hisp/dhis/completeness/jdbc/JDBCDataSetCompletenessStore.java 2012-07-20 08:57:31 +0000 @@ -38,7 +38,6 @@ import org.hisp.dhis.completeness.DataSetCompletenessStore; import org.hisp.dhis.dataset.DataSet; import org.hisp.dhis.jdbc.StatementBuilder; -import org.hisp.dhis.system.util.TextUtils; /** * @author Lars Helge Overland @@ -147,21 +146,6 @@ // ------------------------------------------------------------------------- // Based on number of data values // ------------------------------------------------------------------------- - - public Integer getNumberOfValues( DataSet dataSet, Collection children, Collection periods ) - { - final String childrenIds = TextUtils.getCommaDelimitedString( children ); - - final String sql = - "SELECT count(*) FROM datavalue dv " + - "JOIN datasetmembers dsm ON dv.dataelementid=dsm.dataelementid " + - "JOIN dataset ds ON dsm.datasetid=ds.datasetid " + - "WHERE ds.datasetid = " + dataSet.getId() + " " + - "AND periodid IN ( " + getCommaDelimitedString( periods ) + " ) " + - "AND sourceid IN (" + childrenIds + ")"; - - return statementManager.getHolder().queryForInteger( sql ); - } public Collection getDataSetsWithRegistrations( Collection dataSets ) {