Sort with ignore case in an aggregation

Question

I am trying to sort my result with the case insensitive option. So here is my code:

List<AggregationOperation> operations = new ArrayList<>();   
Sort.Order sort = ....ignoreCase();
operations.add(new SortOperation(new Sort(sort)));

But when I execute my query using an aggregation, it doesn't work:

mongoOperations.aggregate(Aggregation.newAggregation(operations).withOptions(aggregationOptions)

I displayed the query in the debug console and the ignoreCase totally disappeared in the aggregation:

db.getCollection('persons').aggregate([   
    {  
      "$sort":{  
        "buyer.organization.name":-1
      }
    }
])

How can I put the ignore case option in my aggregation?

Thanks for your help!

score 1 · Accepted Answer · answered Aug 09 '18 at 08:08

1

The solution for this was using MongoDB Collation and add it in the mongoOperations. I used strength = 1 which ignores cases.

answered Aug 09 '18 at 08:08

Anna

839
2
17
33

Can you provide an example, please? – Rodolfo Velasco Oct 29 '20 at 02:19

score 0 · Answer 2 · answered Oct 29 '20 at 15:55

This is how I solved my sorting issue

val res =
          mongoTemplate.aggregate(
              aggregations.withOptions(
                  new AggregationOptions(
                      false,
                      false,
                      null,
                      Collation.of("en").strength(Collation.ComparisonLevel.primary()))),
              Path.class,
              CountedAggregationFolderContentDTO.class);

Sort with ignore case in an aggregation

2 Answers2