protected void checkSortOp(DataSet dataSet, DataSetSort op) { for (ColumnSort columnSort : op.getColumnSortList()) { String id = columnSort.getColumnId(); if (dataSet.getColumnById(id) == null) { throw new IllegalArgumentException("Sort column not found in the data set: " + id); } } }
public List<Integer> sort(DataSet dataSet, List<Integer> rowNumbers, List<ColumnSort> columnSortList) { // Create the comparator. DataSetRowComparator comparator = new DataSetRowComparator(); for (ColumnSort columnSort : columnSortList) { DataColumn column = dataSet.getColumnById(columnSort.getColumnId()); if (column == null) throw new IllegalArgumentException("Sort column not found: " + columnSort.getColumnId()); comparator.criteria(column, columnSort.getOrder()); } // Create the row number list to sort. List<Integer> rows = new ArrayList<Integer>(); if (rowNumbers != null) { rows.addAll(rowNumbers); } else { for (int i=0; i<dataSet.getRowCount(); i++) { rows.add(i); } } // Sort the row numbers. Collections.sort(rows, comparator); return rows; } }
public JsonObject formatColumnSort(ColumnSort columnSort) throws JsonException { if (columnSort == null) { return null; } JsonObject columnSortJson = Json.createObject(); columnSortJson.put(COLUMN, columnSort.getColumnId() != null ? columnSort.getColumnId() : null); columnSortJson.put(SORTORDER, columnSort.getOrder() != null ? columnSort.getOrder().toString() : null); return columnSortJson; }
public JsonObject formatColumnSort(ColumnSort columnSort) throws JsonException { if (columnSort == null) { return null; } JsonObject columnSortJson = Json.createObject(); columnSortJson.put(COLUMN, columnSort.getColumnId() != null ? columnSort.getColumnId() : null); columnSortJson.put(SORTORDER, columnSort.getOrder() != null ? columnSort.getOrder().toString() : null); return columnSortJson; }
protected void _appendOrderBy(DataSetSort sortOp) { List<SortColumn> _columns = new ArrayList<>(); List<ColumnSort> sortList = sortOp.getColumnSortList(); for (ColumnSort columnSort : sortList) { String dbColumnId = _columnFromMetadata(metadata, columnSort.getColumnId()); if (SortOrder.DESCENDING.equals(columnSort.getOrder())) { _columns.add(SQLFactory.column(dbColumnId).desc()); } else { _columns.add(SQLFactory.column(dbColumnId).asc()); } } _query.orderBy(_columns); }
protected void _appendOrderBy(DataSetSort sortOp) { List<SortColumn> _columns = new ArrayList<>(); List<ColumnSort> sortList = sortOp.getColumnSortList(); for (ColumnSort columnSort : sortList) { String dbColumnId = _columnFromMetadata(metadata, columnSort.getColumnId()); if (SortOrder.DESCENDING.equals(columnSort.getOrder())) { _columns.add(SQLFactory.column(dbColumnId).desc()); } else { _columns.add(SQLFactory.column(dbColumnId).asc()); } } _query.orderBy(_columns); }
GroupFunction gf = groupOp.getGroupFunction(cs.getColumnId()); if (cg.getSourceId().equals(cs.getColumnId()) || cg.getColumnId().equals(cs.getColumnId())) { if (SortOrder.DESCENDING.equals(cs.getOrder())) { _columns.add(_createColumn(cg).desc());
GroupFunction gf = groupOp.getGroupFunction(cs.getColumnId()); if (cg.getSourceId().equals(cs.getColumnId()) || cg.getColumnId().equals(cs.getColumnId())) { if (SortOrder.DESCENDING.equals(cs.getOrder())) { _columns.add(_createColumn(cg).desc());
StringBuilder orderBy = new StringBuilder(); for (ColumnSort cSort : sort.getColumnSortList()) { orderBy.append(cSort.getColumnId()).append(","); sortOrder = cSort.getOrder();
StringBuilder orderBy = new StringBuilder(); for (ColumnSort cSort : sort.getColumnSortList()) { orderBy.append(cSort.getColumnId()).append(","); sortOrder = cSort.getOrder();