/** * PUBLIC: * Add the ordering expression. This allows for ordering across relationships or functions. * Example: readAllQuery.addOrdering(expBuilder.get("address").get("city").toUpperCase().descending()) */ public void addOrdering(Expression orderingExpression) { getOrderByExpressions().add(orderingExpression); //Bug2804042 Must un-prepare if prepared as the SQL may change. setIsPrepared(false); setShouldOuterJoinSubclasses(true); }
/** * PUBLIC: * Add the ordering expression. This allows for ordering across relationships or functions. * Example: readAllQuery.addOrdering(expBuilder.get("address").get("city").toUpperCase().descending()) */ public void addOrdering(Expression orderingExpression) { getOrderByExpressions().add(orderingExpression); //Bug2804042 Must un-prepare if prepared as the SQL may change. setIsPrepared(false); setShouldOuterJoinSubclasses(true); }
/** * PUBLIC: * Add the ordering expression. This allows for ordering across relationships or functions. * Example: readAllQuery.addOrdering(expBuilder.get("address").get("city").toUpperCase().descending()) */ public void addOrdering(Expression orderingExpression) { getOrderByExpressions().add(orderingExpression); //Bug2804042 Must un-prepare if prepared as the SQL may change. setIsPrepared(false); setShouldOuterJoinSubclasses(true); }
return false; List orderBys = getOrderByExpressions(); List otherOrderBys = query.getOrderByExpressions(); int size = orderBys.size(); if (size != otherOrderBys.size()) {
return false; List orderBys = getOrderByExpressions(); List otherOrderBys = query.getOrderByExpressions(); int size = orderBys.size(); if (size != otherOrderBys.size()) {
/** * INTERNAL: * Clone the query */ public Object clone() { ObjectLevelReadQuery cloneQuery = (ObjectLevelReadQuery)super.clone(); // Must also clone the joined expressions as always joined attribute will be added // don't use setters as this will trigger unprepare. if (cloneQuery.hasJoining()) { cloneQuery.joinedAttributeManager = (JoinedAttributeManager)cloneQuery.getJoinedAttributeManager().clone(); cloneQuery.joinedAttributeManager.setBaseQuery(cloneQuery); } if (hasNonFetchJoinedAttributeExpressions()){ cloneQuery.setNonFetchJoinAttributeExpressions(new ArrayList<Expression>(this.nonFetchJoinAttributeExpressions)); } // Don't use setters as that will trigger unprepare if (hasOrderByExpressions()) { cloneQuery.orderByExpressions = new ArrayList<Expression>(getOrderByExpressions()); } return cloneQuery; }
return false; List orderBys = getOrderByExpressions(); List otherOrderBys = query.getOrderByExpressions(); int size = orderBys.size(); if (size != otherOrderBys.size()) {
if (collectionMapping.getSelectionQuery() instanceof ObjectLevelReadQuery) { ObjectLevelReadQuery readQuery = (ObjectLevelReadQuery) collectionMapping.getSelectionQuery(); List<Expression> orderByExpressions = readQuery.getOrderByExpressions(); for (Expression expression : orderByExpressions) { if (expression instanceof FunctionExpression) {
selectStatement.setOrderByExpressions(cloneExpressions(query.getOrderByExpressions(), clonedExpressions));
selectStatement.setOrderByExpressions(cloneExpressions(query.getOrderByExpressions(), clonedExpressions));
selectStatement.setOrderByExpressions(cloneExpressions(query.getOrderByExpressions(), clonedExpressions));
for (Expression orderBy : readQuery.getOrderByExpressions()) { appendExpressionToSortRow(orderBy, sort, query);