=== modified file 'dhis-2/dhis-support/dhis-support-jdbc/src/main/java/org/hisp/dhis/jdbc/StatementBuilder.java' --- dhis-2/dhis-support/dhis-support-jdbc/src/main/java/org/hisp/dhis/jdbc/StatementBuilder.java 2015-09-18 17:10:13 +0000 +++ dhis-2/dhis-support/dhis-support-jdbc/src/main/java/org/hisp/dhis/jdbc/StatementBuilder.java 2015-09-23 14:00:30 +0000 @@ -169,9 +169,6 @@ String getAverage( int dataElementId, int categoryOptionComboId, int organisationUnitId ); - String getDeflatedDataValues( int dataElementId, String dataElementName, int categoryOptionComboId, - String periodIds, int organisationUnitId, String organisationUnitName, int lowerBound, int upperBound ); - String getAddDate( String dateField, int days ); String queryDataElementStructureForOrgUnit(); === modified file 'dhis-2/dhis-support/dhis-support-jdbc/src/main/java/org/hisp/dhis/jdbc/statementbuilder/H2StatementBuilder.java' --- dhis-2/dhis-support/dhis-support-jdbc/src/main/java/org/hisp/dhis/jdbc/statementbuilder/H2StatementBuilder.java 2015-09-23 13:58:30 +0000 +++ dhis-2/dhis-support/dhis-support-jdbc/src/main/java/org/hisp/dhis/jdbc/statementbuilder/H2StatementBuilder.java 2015-09-23 14:00:30 +0000 @@ -158,26 +158,6 @@ } @Override - public String getDeflatedDataValues( int dataElementId, String dataElementName, int categoryOptionComboId, - String periodIds, int organisationUnitId, String organisationUnitName, int lowerBound, int upperBound ) - { - return "SELECT dv.dataelementid, dv.periodid, dv.sourceid, dv.categoryoptioncomboid, dv.value, dv.storedby, dv.lastupdated, " + - "dv.comment, dv.followup, '" + lowerBound + "' AS minimumvalue, '" + upperBound + "' AS maximumvalue, " + - encode( dataElementName ) + " AS dataelementname, pt.name AS periodtypename, pe.startdate, pe.enddate, " + - encode( organisationUnitName ) + " AS sourcename, cc.name " + - "FROM datavalue AS dv " + - "JOIN period AS pe USING (periodid) " + - "JOIN periodtype AS pt USING (periodtypeid) " + - "LEFT JOIN categoryoptioncombo AS cc USING (categoryoptioncomboid) " + - "WHERE dv.dataelementid='" + dataElementId + "' " + - "AND dv.categoryoptioncomboid='" + categoryOptionComboId + "' " + - "AND dv.periodid IN (" + periodIds + ") " + - "AND dv.sourceid='" + organisationUnitId + "' " + - "AND ( CAST( dv.value AS " + getDoubleColumnType() + " ) < '" + lowerBound + "' " + - "OR CAST( dv.value AS " + getDoubleColumnType() + " ) > '" + upperBound + "' )"; - } - - @Override public String getAddDate( String dateField, int days ) { return "DATEADD('DAY'," + days + "," + dateField + ")"; === modified file 'dhis-2/dhis-support/dhis-support-jdbc/src/main/java/org/hisp/dhis/jdbc/statementbuilder/HsqlStatementBuilder.java' --- dhis-2/dhis-support/dhis-support-jdbc/src/main/java/org/hisp/dhis/jdbc/statementbuilder/HsqlStatementBuilder.java 2015-09-23 13:58:30 +0000 +++ dhis-2/dhis-support/dhis-support-jdbc/src/main/java/org/hisp/dhis/jdbc/statementbuilder/HsqlStatementBuilder.java 2015-09-23 14:00:30 +0000 @@ -158,26 +158,6 @@ } @Override - public String getDeflatedDataValues( int dataElementId, String dataElementName, int categoryOptionComboId, - String periodIds, int organisationUnitId, String organisationUnitName, int lowerBound, int upperBound ) - { - return "SELECT dv.dataelementid, dv.periodid, dv.sourceid, dv.categoryoptioncomboid, dv.value, dv.storedby, dv.lastupdated, " + - "dv.comment, dv.followup, '" + lowerBound + "' AS minimumvalue, '" + upperBound + "' AS maximumvalue, " + - encode( dataElementName ) + " AS dataelementname, pt.name AS periodtypename, pe.startdate, pe.enddate, " + - encode( organisationUnitName ) + " AS sourcename, cc.name " + - "FROM datavalue AS dv " + - "JOIN period AS pe USING (periodid) " + - "JOIN periodtype AS pt USING (periodtypeid) " + - "LEFT JOIN categoryoptioncombo AS cc USING (categoryoptioncomboid) " + - "WHERE dv.dataelementid='" + dataElementId + "' " + - "AND dv.categoryoptioncomboid='" + categoryOptionComboId + "' " + - "AND dv.periodid IN (" + periodIds + ") " + - "AND dv.sourceid='" + organisationUnitId + "' " + - "AND ( CAST( dv.value AS " + getDoubleColumnType() + " ) < '" + lowerBound + "' " + - "OR CAST( dv.value AS " + getDoubleColumnType() + " ) > '" + upperBound + "' )"; - } - - @Override public String getAddDate( String dateField, int days ) { return "DATEADD('DAY'," + days + "," + dateField + ")"; === modified file 'dhis-2/dhis-support/dhis-support-jdbc/src/main/java/org/hisp/dhis/jdbc/statementbuilder/MySQLStatementBuilder.java' --- dhis-2/dhis-support/dhis-support-jdbc/src/main/java/org/hisp/dhis/jdbc/statementbuilder/MySQLStatementBuilder.java 2015-09-23 13:58:30 +0000 +++ dhis-2/dhis-support/dhis-support-jdbc/src/main/java/org/hisp/dhis/jdbc/statementbuilder/MySQLStatementBuilder.java 2015-09-23 14:00:30 +0000 @@ -164,26 +164,6 @@ } @Override - public String getDeflatedDataValues( int dataElementId, String dataElementName, int categoryOptionComboId, - String periodIds, int organisationUnitId, String organisationUnitName, int lowerBound, int upperBound ) - { - return "SELECT dv.dataelementid, dv.periodid, dv.sourceid, dv.categoryoptioncomboid, dv.value, dv.storedby, dv.lastupdated, " + - "dv.comment, dv.followup, '" + lowerBound + "' AS minimumvalue, '" + upperBound + "' AS maximumvalue, " + - encode( dataElementName ) + " AS dataelementname, pt.name AS periodtypename, pe.startdate, pe.enddate, " + - encode( organisationUnitName ) + " AS sourcename, cc.name " + - "FROM datavalue dv " + - "JOIN period pe USING (periodid) " + - "JOIN periodtype pt USING (periodtypeid) " + - "LEFT JOIN categoryoptioncombo cc USING (categoryoptioncomboid) " + - "WHERE dv.dataelementid='" + dataElementId + "' " + - "AND dv.categoryoptioncomboid='" + categoryOptionComboId + "' " + - "AND dv.periodid IN (" + periodIds + ") " + - "AND dv.sourceid='" + organisationUnitId + "' " + - "AND ( dv.value < '" + lowerBound + "' " + - "OR dv.value > '" + upperBound + "' )"; - } - - @Override public String getAddDate( String dateField, int days ) { return "ADDDATE(" + dateField + "," + days + ")"; === modified file 'dhis-2/dhis-support/dhis-support-jdbc/src/main/java/org/hisp/dhis/jdbc/statementbuilder/PostgreSQLStatementBuilder.java' --- dhis-2/dhis-support/dhis-support-jdbc/src/main/java/org/hisp/dhis/jdbc/statementbuilder/PostgreSQLStatementBuilder.java 2015-09-23 13:58:30 +0000 +++ dhis-2/dhis-support/dhis-support-jdbc/src/main/java/org/hisp/dhis/jdbc/statementbuilder/PostgreSQLStatementBuilder.java 2015-09-23 14:00:30 +0000 @@ -182,26 +182,6 @@ } @Override - public String getDeflatedDataValues( int dataElementId, String dataElementName, int categoryOptionComboId, - String periodIds, int organisationUnitId, String organisationUnitName, int lowerBound, int upperBound ) - { - return "SELECT dv.dataelementid, dv.periodid, dv.sourceid, dv.categoryoptioncomboid, dv.value, dv.storedby, dv.lastupdated, " + - "dv.comment, dv.followup, '" + lowerBound + "' AS minimumvalue, '" + upperBound + "' AS maximumvalue, " + - encode( dataElementName ) + " AS dataelementname, pt.name AS periodtypename, pe.startdate, pe.enddate, " + - encode( organisationUnitName ) + " AS sourcename, cc.name " + - "FROM datavalue AS dv " + - "JOIN period AS pe USING (periodid) " + - "JOIN periodtype AS pt USING (periodtypeid) " + - "LEFT JOIN categoryoptioncombo AS cc USING (categoryoptioncomboid) " + - "WHERE dv.dataelementid='" + dataElementId + "' " + - "AND dv.categoryoptioncomboid='" + categoryOptionComboId + "' " + - "AND dv.periodid IN (" + periodIds + ") " + - "AND dv.sourceid='" + organisationUnitId + "' " + - "AND ( CAST( dv.value AS " + getDoubleColumnType() + " ) < '" + lowerBound + "' " + - "OR CAST( dv.value AS " + getDoubleColumnType() + " ) > '" + upperBound + "' )"; - } - - @Override public String getAddDate( String dateField, int days ) { return "(" + dateField + "+" + days + ")";