Spring data mongoRepository Query sort

Question

I was looking to see how I could introduce a sort into a Query annotation in a repository method that I have. I already saw this code in Google and here, but I could not make it works

@Query("find({state:'ACTIVE'}).sort({created:-1}).limit(1)")
    Job findOneActiveOldest();

@Query("{ state:'ACTIVE', $orderby: {created:-1}, $limit:1 }")
Job findOneActiveOldest();

I know that with pagination I can make it, but in some cases I don't need paginate, so I was wondering how to make it with Query annotation.

Any suggestion please?

JSONParse Exception in the case of the first one, and the second one dont return anything. — paul, May 17 '13 at 11:59
Isn't it your question? http://stackoverflow.com/questions/10067169/query-with-sort-and-limt-in-spring-repository-interface — kabochkov, May 17 '13 at 12:33
No, take a look of the second answer of that question and read carefully my question/response — paul, May 20 '13 at 07:08

score 25 · Accepted Answer · answered May 22 '13 at 18:40

25

I don't think it is possible to do it with @Query annotation. If you dont need to paginate you can just make your repository method use Sort parameter:

@Query("{ state:'ACTIVE' }")
Job findOneActive(Sort sort);

and use it:

yourRepository.findOneActive(new Sort(Sort.Direction.DESC, "created"))

answered May 22 '13 at 18:40

Maciej Walkowiak

12,372
59
63

Is a good solution thanks!. Still I cannot believe how bas is Query annotation for Mongo. – paul May 23 '13 at 08:17
2

That's true there is still place for improvement there. Good thing is that Spring sources are on github so you can always code an enhancement and create pull request with it – Maciej Walkowiak May 23 '13 at 08:51
2

What if I do need to paginate? – Nailgun Mar 29 '16 at 19:28
@MaciejWalkowiak how to add limit to this. please advice – Mohanraj Dec 14 '18 at 07:39
If you use limit and offset it will not work, it's work around. – Sérgio Thiago Mendonça Jan 28 '21 at 19:29
Now Limit and sorting is possible in @Query – Pushpender Singh Dec 30 '22 at 18:27

score 16 · Answer 2 · answered Sep 24 '19 at 12:35

16

Just use sort parameter of @Query annotation. 1 = ASC, -1 = DESC

    @Query(
        value  = ...,
        sort = "{'details.requestTime': -1}"
    )

answered Sep 24 '19 at 12:35

lukyer

7,595
3
37
31

How to perform group-by ? – PAA Apr 06 '20 at 08:55
It is the correct response, without work around! Excelent. – Sérgio Thiago Mendonça Jan 28 '21 at 19:31

score 0 · Answer 3 · edited Nov 14 '18 at 10:53

0

if you also want to have pagination then use Pageable as method argument instead of Sort. Try below code:

@Query("{ state:'ACTIVE' }")
Job findOneActive(Pageable pageable);

yourRepository.findOneActive(new PageRequest(0, 1, new Sort(Sort.Direction.DESC,"created")));

edited Nov 14 '18 at 10:53

Rahul Agarwal

4,034
7
27
51

answered Nov 14 '18 at 09:58

rahul nagpal

1

Spring data mongoRepository Query sort

3 Answers3