Query on 2 properties of the same embedded object in an array

Question

I have a Collection of objects :

db.coll.find().pretty();

{
    "_id" : "1",
    "elements" : [
        { "key" : "A", "value" : 10 },
        { "key" : "B", "value" : 1 },
    ]
}, 
{
    "_id" : "2",
    "elements" : [
        { "key" : "A", "value" : 1 },
        { "key" : "C", "value" : 33 },
    ]
}

I want to find the documents that contain an element with "key" equal to "A" AND its "value" is greater than 5.

Not sure if this is possible without using the aggregation framework.

Neo-coder · Accepted Answer · 2016-07-25 17:15:21Z

1

Without aggregation, using $elemMatch and query will be as below :

db.coll.find({"elements":{"$elemMatch":{"$and":[{"key":"A"},{"value":{"$gt":5}}]}}}).pretty()

or if you want use aggregation then used following query for aggregation

db.coll.aggregate({"$unwind":"$elements"},{"$match":{"$and":[{"elements.key":"A"},{"elements.value":{"$gt":5}}]}}).pretty()

answered Jul 25, 2016 at 17:15

Neo-coder

7,8585 gold badges36 silver badges54 bronze badges

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

Comments

Andriy Simonov · Accepted Answer · 2016-07-25 17:18:22Z

1

Here is the query

db.coll.find({elements: {$elemMatch: {key: "A", value: {$gt: 5}}}});

It uses $elemMatch operator. The $elemMatch operator matches documents that contain an array field with at least one element that matches all the specified query criteria. (Refer the documentation)

answered Jul 25, 2016 at 17:18

Andriy Simonov

1,3081 gold badge12 silver badges22 bronze badges

Collectives™ on Stack Overflow

Query on 2 properties of the same embedded object in an array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related