Spring data mongodb sort on multiple fields

Question

I want to sort on multiple fields in MongoDB using Spring data for MongoDB. Currently I am trying to achieve this using aggregation:

    Aggregation agg = newAggregation( 
            match(Criteria.where("userId").is(userId)), 
            sort(Sort.Direction.DESC, "type", "createdDate"), 
    );
    AggregationResults<MyBean> results = mongoOperations.aggregate(agg, MyBean.class, MyBean.class);

When I am doing this, it is sorting on the type and createdDate on DESC order. But I want DESC on type and ASC on createdDate.

I tried,

    sort(Sort.Direction.DESC, "type");
    sort(Sort.Direction.ASC, "createdDate");

but this is sorting only on createdDate.

s7vr · Accepted Answer · 2017-01-18 15:48:16Z

6

You can try something like this.

Aggregation agg = newAggregation(
        match(Criteria.where("userId").is(userId)),
        sort(Sort.Direction.DESC, "type").and(Sort.Direction.ASC, "createdDate")
);

answered Jan 18, 2017 at 15:48

s7vr

76.2k12 gold badges118 silver badges135 bronze badges

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

Comments

Alexey Simonov · Accepted Answer · 2017-11-04 08:12:59Z

4

Little bit late, but for other people... Try this (for spring-data):

private static final Sort NOTE_SORT = new Sort(new Sort.Order(Sort.Direction.ASC, "seen"),
                                                new Sort.Order(Sort.Direction.DESC, "date"),
                                                new Sort.Order(Sort.Direction.ASC, "done"));

answered Nov 4, 2017 at 8:12

Alexey Simonov

4254 silver badges12 bronze badges

Comments

Ashish Bakwad · Accepted Answer · 2017-01-21 09:25:46Z

3

You can create order list and use it for sort like this

List<Order> orders = new ArrayList<>();
orderQuery.add(new Order(Direction.DESC, "createdDate"));
Sort sorts = new Sort(orders.toArray(new Order[orders.size()]));    
Aggregation agg = newAggregation(
        match(Criteria.where("userId").is(userId)),
        sort(sorts)
);

answered Jan 21, 2017 at 9:25

Ashish Bakwad

8115 silver badges16 bronze badges

Comments

siddhartha agarwal · Accepted Answer · 2022-02-08 08:23:06Z

Simple sorting without Aggregation object

import org.springframework.data.domain.Sort;
import org.springframework.data.mongodb.core.MongoTemplate;

//query: existing mongo query
//mongoTemplate: @Autowired MongoTemplate object
//First create a list of Sort.Order and add multiple criteria's

List<Sort.Order> sortOnMultipleFIelds = new ArrayList<>();
            sortOnMultipleFIelds.add(new Sort.Order(Sort.Direction.DESC, "Field1"));
            sortOnMultipleFIelds.add(new Sort.Order(Sort.Direction.ASC, "Field2"));
            sortOnMultipleFIelds.add(new Sort.Order(Sort.Direction.DESC, "Field3"));


//Apply it on Query
            query.with(Sort.by(sortOnMultipleFIelds);

//Execute query
            List<ClassName> resultList= mongoTemplate.find(query, ClassName.class);

Collectives™ on Stack Overflow

Spring data mongodb sort on multiple fields

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related