How to add orderby using @query in mongodb repository

Question

I want to add orderby to the following repository method in mongodb with spring. I tried in various methods, but didnt work

public interface StageRepository extends MongoRepository<Stage, String> {

     @Query("{$and: [ { 'categoryId': { $eq: ?0 } }, { 'isDeleted': { $eq: ?1 } } ]}")
     public List<Stage> findByCategoryIdAndIsNotDeleted(String categoryId, Boolean deleted);

}

I want to add orderby 'order' in the query.

Not sure how to do it.

score 10 · Accepted Answer · edited Mar 17 '16 at 12:08

10

You can do like :

@Query("{$and: [ { 'categoryId': { $eq: ?0 } }, { 'isDeleted': { $eq: ?1 } } ]}")
public List<Stage> findByCategoryIdAndIsNotDeleted(String categoryId, Boolean deleted,org.springframework.data.domain.Sort sort);

And When you call this method ,create Sort object like below:

Sort sort = new Sort(Direction.ASC/DESC,"order");

edited Mar 17 '16 at 12:08

Kees de Kooter

7,078
5
38
45

answered Oct 08 '15 at 13:41

Viresh

304
2
3

how to add limit to this – Mohanraj Dec 14 '18 at 08:32
1

for springboot2.2.1+, Sort sort = Sort.by(Sort.Direction.DESC, "order"); – Will Apr 07 '21 at 04:11

How to add orderby using @query in mongodb repository

1 Answers1

Linked