How can I convert a spring data Sort to a querydsl OrderSpecifier?

spring-data querydsl
beginner_ picture beginner_ · Oct 25, 2012 · Viewed 20.2k times · Source

This is basically the opposite of this: How to do a paged QueryDSL query with Spring JPA?

This is for a custom query for which i can't use any of the findAll() methods.

EDIT:

Posted the wrong link. Now corrected.

Answer

Frank picture Frank · Oct 27, 2012

You can do somethings like this: But make sure to trim the o.getProperty() so you only pass the property and not "alias."+property

if (pageable != null) {
    query.offset(pageable.getOffset());
    query.limit(pageable.getPageSize());
    for (Sort.Order o : pageable.getSort()) {
        PathBuilder<Object> orderByExpression = new PathBuilder<Object>(Object.class, "object");

        query.orderBy(new OrderSpecifier(o.isAscending() ? com.mysema.query.types.Order.ASC
                : com.mysema.query.types.Order.DESC, orderByExpression.get(o.getProperty())));
    }
}

Related questions

Dynamic spring data jpa repository query with arbitrary AND clauses

I'm using Spring data jpa repositories, Got a requirement to give search feature with different fields. Entering fields before search is optional.I have 5 fields say EmployeeNumber, Name, Married,Profession and DateOfBirth. Here i need to query only with the …

Read More
QueryDsl - subquery in collection expression

I'm using spring-data-jpa and querydsl (3.2.3) I have a scenario where I'm creating set of predicates based on user filer/input. All of these comes to BooleanExpression. My simplified model looks as following: @Entity public class Invoice { @ManyToOne private Supplier supplier; } @…

Read More
Spring-Data-JPA with QueryDslPredicateExecutor and Joining into a collection

Let's say I have a data model like this (pseudocode): @Entity Person { @OneToMany List<PersonAttribute> attributes; } @Entity PersonAttribute { @ManyToOne AttributeName attributeName; String attributeValue; } @Entity AttributeName { String name; } I have a Spring-Data-JPA repository defined such as: public interface PersonRepository …

Read More