private String toOrderByStatement(final List<OrderByClause> orderByClauses) { StringBuilder statement = new StringBuilder(); for (OrderByClause clause : orderByClauses) { String field = clause.getField().trim(); if (ReflectionUtils.findField(JPAReportExec.class, field) != null) { statement.append("e.").append(field).append(' ').append(clause.getDirection().name()); } } if (statement.length() == 0) { statement.append("ORDER BY e.id DESC"); } else { statement.insert(0, "ORDER BY "); } return statement.toString(); }
private String toOrderByStatement(final List<OrderByClause> orderByClauses) { StringBuilder statement = new StringBuilder(); for (OrderByClause clause : orderByClauses) { String field = clause.getField().trim(); if (ReflectionUtils.findField(JPAAccessToken.class, field) != null) { statement.append("e.").append(field).append(' ').append(clause.getDirection().name()); } } if (statement.length() == 0) { statement.append("ORDER BY e.expiryTime DESC"); } else { statement.insert(0, "ORDER BY "); } return statement.toString(); }
private String toOrderByStatement(final List<OrderByClause> orderByClauses) { StringBuilder statement = new StringBuilder(); for (OrderByClause clause : orderByClauses) { String field = clause.getField().trim(); if (ReflectionUtils.findField(JPATaskExec.class, field) != null) { statement.append("e.").append(field).append(' ').append(clause.getDirection().name()); } } if (statement.length() == 0) { statement.append("ORDER BY e.id DESC"); } else { statement.insert(0, "ORDER BY "); } return statement.toString(); }
String field = clause.getField().trim(); switch (field) { case "latestExecStatus":
queryString.append(" ORDER BY "); orderByClauses.forEach(clause -> { String field = clause.getField().trim(); boolean ack = true; if ("resource".equals(field)) {
@Override public <T extends Any<?>> List<T> search( final Set<String> adminRealms, final SearchCond cond, final int page, final int itemsPerPage, final List<OrderByClause> orderBy, final AnyTypeKind kind) { if (adminRealms == null || adminRealms.isEmpty()) { LOG.error("No realms provided"); return Collections.<T>emptyList(); } LOG.debug("Search condition:\n{}", cond); if (cond == null || !cond.isValid()) { LOG.error("Invalid search condition:\n{}", cond); return Collections.<T>emptyList(); } List<OrderByClause> effectiveOrderBy; if (orderBy.isEmpty()) { OrderByClause keyClause = new OrderByClause(); keyClause.setField(kind == AnyTypeKind.USER ? "username" : "name"); keyClause.setDirection(OrderByClause.Direction.ASC); effectiveOrderBy = Collections.singletonList(keyClause); } else { effectiveOrderBy = orderBy.stream(). filter(clause -> !ArrayUtils.contains(ORDER_BY_NOT_ALLOWED, clause.getField())). collect(Collectors.toList()); } return doSearch(adminRealms, cond, page, itemsPerPage, effectiveOrderBy, kind); }
OrderBySupport.Item item = new OrderBySupport.Item(); if (anyUtils.getField(clause.getField()) == null) { PlainSchema schema = schemaDAO.find(clause.getField()); if (schema != null) { if (schema.isUniqueConstraint()) { throw invalidSearch; parseOrderByForPlainSchema(svs, obs, item, clause, schema, clause.getField()); String fieldName = "key".equals(clause.getField()) ? "id" : clause.getField();
-> new SortKey(clause.getField(), clause.getDirection() == OrderByClause.Direction.ASC)). collect(Collectors.toList()));