List<DataSetGroup> dataSetGroups = lookup.getFirstGroupOpSelections(); for (DataSetGroup group : dataSetGroups) { if (group.getSelectedIntervalList() != null && group.getSelectedIntervalList().size() > 0) {
List<DataSetGroup> dataSetGroups = lookup.getFirstGroupOpSelections(); for (DataSetGroup group : dataSetGroups) { if (group.getSelectedIntervalList()!=null && group.getSelectedIntervalList().size()>0) {
protected Date calculateDateLimit(String dateColumnId, boolean min) { String dbColumnId = _columnFromMetadata(metadata, dateColumnId); Column _dateColumn = SQLFactory.column(dbColumnId); Select _limitsQuery = SQLFactory.select(conn).columns(_dateColumn); _appendFrom(def, _limitsQuery); // Append the filter clauses for (DataSetFilter filterOp : lookup.getOperationList(DataSetFilter.class)) { _appendFilterBy(metadata, def, filterOp, _limitsQuery); } // Append group interval selection filters List<DataSetGroup> intervalSelects = lookup.getFirstGroupOpSelections(); for (DataSetGroup intervalSelect : intervalSelects) { _appendIntervalSelection(intervalSelect, _limitsQuery); } try { // Fetch the date ResultSet rs = logSQL(_limitsQuery .where(_dateColumn.notNull()) .orderBy(min ? _dateColumn.asc() : _dateColumn.desc()) .limit(1)).fetch(); if (!rs.next()) { return null; } else { return rs.getDate(1); } } catch (SQLException e) { log.error("Error reading date limit from query results", e); return null; } }
protected Date calculateDateLimit(String dateColumnId, boolean min) { String dbColumnId = _columnFromMetadata(metadata, dateColumnId); Column _dateColumn = SQLFactory.column(dbColumnId); Select _limitsQuery = SQLFactory.select(conn).columns(_dateColumn); _appendFrom(def, _limitsQuery); // Append the filter clauses for (DataSetFilter filterOp : lookup.getOperationList(DataSetFilter.class)) { _appendFilterBy(metadata, def, filterOp, _limitsQuery); } // Append group interval selection filters List<DataSetGroup> intervalSelects = lookup.getFirstGroupOpSelections(); for (DataSetGroup intervalSelect : intervalSelects) { _appendIntervalSelection(intervalSelect, _limitsQuery); } try { // Fetch the date ResultSet rs = logSQL(_limitsQuery .where(_dateColumn.notNull()) .orderBy(min ? _dateColumn.asc() : _dateColumn.desc()) .limit(1)).fetch(); if (!rs.next()) { return null; } else { return rs.getDate(1); } } catch (SQLException e) { log.error("Error reading date limit from query results", e); return null; } }
List<DataSetGroup> intervalSelects = lookup.getFirstGroupOpSelections(); for (DataSetGroup intervalSelect : intervalSelects) { _appendIntervalSelection(intervalSelect, _query);
List<DataSetGroup> intervalSelects = lookup.getFirstGroupOpSelections(); for (DataSetGroup intervalSelect : intervalSelects) { _appendIntervalSelection(intervalSelect, _query);