Announcement Announcement Module
Collapse
No announcement yet.
How to use order by and Limit in Spring Data JPA using QueryDSL Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to use order by and Limit in Spring Data JPA using QueryDSL

    I am using Spring Data JPA with a RDBMS in my project. I have a requirement where I have to fetch a single record from the Database from a table which has the latest date. For this I need to use a limit and order by function OR using sub queries. However, I wished to know if i wish for not to use NamedQuery is there a way I can achieve this using Spring Data JPA and QueryDSL.

  • #2
    Have a look at QueryDslPredicateExecuter.findAll(Predicate predicate, Pageable pageable). The Pageable (PageRequest is the implementation class you'll want to hand in) allows narrowing down the result set.

    Comment


    • #3
      Thanks

      Originally posted by Oliver Gierke View Post
      Have a look at QueryDslPredicateExecuter.findAll(Predicate predicate, Pageable pageable). The Pageable (PageRequest is the implementation class you'll want to hand in) allows narrowing down the result set.
      Thanks. It worked.

      Comment

      Working...
      X