protected Document walkOrderBy(OrderByList orderByList) { if (orderByList.isEmpty()) { return null; } Document orderBy = new Document(); for (OrderByExpr ob : orderByList) { String field = walkReference(ob.reference).queryField; if (!orderBy.containsKey(field)) { orderBy.put(field, ob.isDescending ? MINUS_ONE : ONE); } } return orderBy; } }
if (orders.get(0).isDescending) { queryStr.append(" DESC"); } else {
new OrderByList(new OrderByExpr(new Reference(NXQL.ECM_FULLTEXT_SCORE), true)), false); queryAnalyzer.orderByScore = true; reAnalyze = true; if (hasSelectCollection) { if (sqlQuery.orderBy == null) { sqlQuery.orderBy = new OrderByClause(new OrderByList()); sqlQuery.orderBy.elements.add(new OrderByExpr(new Reference(NXQL.ECM_UUID), false));
@Override public ScrollResult<String> scroll(QueryBuilder builder, int batchSize, int keepAliveSeconds) { // as we're using pages to scroll audit, we need to add an order to make results across pages deterministic builder.orders(OrderByExprs.asc(LOG_ID), builder.orders().toArray(new OrderByExpr[0])); String scrollId = cursorService.registerCursorResult( new SQLAuditCursorResult(builder, batchSize, keepAliveSeconds)); return scroll(scrollId); }
protected SearchSourceBuilder createSearchRequestSource(MultiExpression predicate, OrderByList orders) { // create ES query builder QueryBuilder query = createQueryBuilder(predicate); // create ES source SearchSourceBuilder source = new SearchSourceBuilder().query(QueryBuilders.constantScoreQuery(query)).size(100); // create sort orders.forEach(order -> source.sort(order.reference.name, order.isDescending ? SortOrder.DESC : SortOrder.ASC)); return source; }
if (!orders.isEmpty()) { for (OrderByExpr ob : orders) { if (orderBy.length() != 0) {
int offset = Math.max(0, (int) queryBuilder.offset()); OrderByList orders = queryBuilder.orders(); boolean order = !orders.isEmpty();
boolean order = !orders.isEmpty(); SearchControls scts = order ? getDirectory().getSearchControls(true) : getDirectory().getIdSearchControls();
if (!orders.isEmpty()) { for (OrderByExpr ob : orders) { if (orderBy.length() != 0) {