Finding Maximum query result using spring-data-jpa @Query annotation

Question

Is is possible to limit query results using .setMaxResults(1).getResultList() and @Query - something like:

@Query("SELECT l FROM LocationLog l WHERE l.visit = :visit ORDER BY l.eventTime").setMaxResults(1).getResultList()
public LocationLog findLast(@Param("visit") Visit visit);

This code is not correct as the setMaxResults and so on is outside the @Query?l

Maciej Dobrowolski · Accepted Answer · 2014-07-28 09:55:38Z

1

You cannot set pagination options in @Query annotation, but it can be done in other way. You can change your method declaration to

public LocationLog find(@Param("visit") Visit visit, Pageable pageable);

Then you will be able to pass additional argument to query invocation:

Pageable firstFive = new PageRequest(0, 5);
LocationLog locLog = locationLogDao.find(visit, firstFive);

There's also option to know current context of the query results you can use Page interface changing method return type to Page<LocationLog>. You can find all necessary informations here.

answered Jul 28, 2014 at 9:55

Maciej Dobrowolski

12.2k5 gold badges50 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Finding Maximum query result using spring-data-jpa @Query annotation

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related