subStatement.append(field).append(' ').append(clause.getDirection().name()).append(','); });
item.orderBy = svs.field().alias + "." + fieldName + " " + clause.getDirection().name();
protected void parseOrderByForPlainSchema( final SearchSupport svs, final OrderBySupport obs, final OrderBySupport.Item item, final OrderByClause clause, final PlainSchema schema, final String fieldName) { // keep track of involvement of non-mandatory schemas in the order by clauses obs.nonMandatorySchemas = !"true".equals(schema.getMandatoryCondition()); if (schema.isUniqueConstraint()) { obs.views.add(svs.asSearchViewSupport().uniqueAttr()); item.select = new StringBuilder(). append(svs.asSearchViewSupport().uniqueAttr().alias).append('.'). append(svs.fieldName(schema.getType())). append(" AS ").append(fieldName).toString(); item.where = new StringBuilder(). append(svs.asSearchViewSupport().uniqueAttr().alias). append(".schema_id='").append(fieldName).append("'").toString(); item.orderBy = fieldName + " " + clause.getDirection().name(); } else { obs.views.add(svs.asSearchViewSupport().attr()); item.select = new StringBuilder(). append(svs.asSearchViewSupport().attr().alias).append('.').append(svs.fieldName(schema.getType())). append(" AS ").append(fieldName).toString(); item.where = new StringBuilder(). append(svs.asSearchViewSupport().attr().alias). append(".schema_id='").append(fieldName).append("'").toString(); item.orderBy = fieldName + " " + clause.getDirection().name(); } }
protected List<OrderByClause> getOrderByClauses(final String orderBy) { if (StringUtils.isBlank(orderBy)) { return Collections.<OrderByClause>emptyList(); } List<OrderByClause> result = new ArrayList<>(); for (String clause : orderBy.split(",")) { String[] elems = clause.split(" "); if (elems.length > 0 && StringUtils.isNotBlank(elems[0])) { OrderByClause obc = new OrderByClause(); obc.setField(elems[0].trim()); if (elems.length > 1 && StringUtils.isNotBlank(elems[1])) { obc.setDirection(elems[1].trim().equalsIgnoreCase(OrderByClause.Direction.ASC.name()) ? OrderByClause.Direction.ASC : OrderByClause.Direction.DESC); } result.add(obc); } } return result; }
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(); }
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(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(); }