/** * Returns a having clause restricting the result based on the measure criteria. */ private String getMeasureCriteriaSql( DataQueryParams params ) { SqlHelper sqlHelper = new SqlHelper(); String sql = " "; for ( MeasureFilter filter : params.getMeasureCriteria().keySet() ) { Double criterion = params.getMeasureCriteria().get( filter ); sql += sqlHelper.havingAnd() + " " + getNumericValueColumn( params ) + " " + OPERATOR_SQL_MAP.get( filter ) + " " + criterion + " "; } return sql; }