MongoDB Java Driver aggregation with regex filter

Question

I am using MongoDB Java Driver 3.6.3. I want to create regex query with group by aggregation to retrieve distinct values.

Let's say I have json:

[{
  "name": "John Snow",
  "category": 1
},
{
  "name": "Jason Statham",
  "category": 2
},
{
  "name": "John Lennon",
  "category": 2
},
{
  "name": "John Snow",
  "category": 3
}]

I want to create query where regex is like "John.*" and group it by name so there would be only one "John Snow"

Expected result is:

[{
  "name": "John Snow",
  "category": 1
},
{
  "name": "John Lennon",
  "category": 2
}]

glytching · Accepted Answer · 2018-03-27 09:59:55Z

3

The answer provided by felix is correct, in terms of Mongo Shell commands. The equivalent expression of that command using the MongoDB Java driver is:

MongoClient mongoClient = ...;

MongoCollection<Document> collection = mongoClient.getDatabase("...").getCollection("...");

AggregateIterable<Document> documents = collection.aggregate(Arrays.asList(

    // Java equivalent of the $match stage
    Aggregates.match(Filters.regex("name", "John")),

    // Java equivalent of the $group stage
    Aggregates.group("$name", Accumulators.first("category", "$category"))

));

for (Document document : documents) {
    System.out.println(document.toJson());
}

The above code will print out:

{ "_id" : "John Lennon", "category" : 2 }  
{ "_id" : "John Snow", "category" : 1 }

edited Mar 27, 2018 at 9:59

answered Mar 26, 2018 at 8:05

glytching

48.5k11 gold badges127 silver badges129 bronze badges

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

Comments

felix · Accepted Answer · 2018-03-26 07:43:34Z

2

You can achieve this with a $regex in $match stage, followed by a $group stage:

db.collection.aggregate([{
    "$match": {
        "name": {
            "$regex": "john",
            "$options": "i"
        }
    }
}, {
    "$group": {
        "_id": "$name",
        "category": {
            "$first": "$category"
        }
    }
}])

output:

[
  {
    "_id": "John Lennon",
    "category": 2
  },
  {
    "_id": "John Snow",
    "category": 1
  }
]

you can try it here: mongoplayground.net/p/evw6DP_574r

answered Mar 26, 2018 at 7:43

felix

9,3158 gold badges44 silver badges65 bronze badges

2 Comments

Frido Over a year ago

Thanks. How to implement it in MongoDB Java Driver?

felix Over a year ago

@Frido take a look at the documentation: mongo-java-driver/aggregation

gaurav singh · Accepted Answer · 2018-03-26 08:57:55Z

0

You can use Spring Data Mongo

like this

    Aggregation agg = Aggregation.newAggregation(
        ggregation.match(ctr.orOperator(Criteria.where("name").regex("john", "i")),
                Aggregation.group("name", "category")
        );
          AggregationResults<CatalogNoArray> aggResults = mongoTemp.aggregate(agg, "demo",demo.class);

answered Mar 26, 2018 at 8:57

gaurav singh

1,4261 gold badge16 silver badges27 bronze badges

Collectives™ on Stack Overflow

MongoDB Java Driver aggregation with regex filter

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest