MongoDB: Find array element which having some value?

Question

{
"_id" : ObjectId("55caf0298c1c44740469306c"),
"data" : {
    "field" : {
        "fields" : [
            {
                "name" : "demo",
                "type" : "data",
                "value" : "A"
            }
        ]
    }
}

}

I want Only those Array element should come where value=A, rest is blank so it should not show.

Desire Output:

{
    "_id" : ObjectId("55caef098c1c447404693064"),
    "data" : {
        "field" : {
            "fields" : [
                {
                    "value" : "A"
                }
            ]
        }
    }
}

And also after finding all values in document I want to modify those values.

Note: value=A is not always first element ,it can be 2nd 3rd element.And in each document "value" : "A" is not not fixed it can be different like "value" : "B", only i want those document where value key is having value and where its blank it should not show.

Query:

db.getCollection('collection').aggregate([
    {$match: {'data.field.fields.name': 'demo'}},
    { "$project": {
        "_id": 0,
        "value": { "$arrayElemAt": ["$data.field.fields.value", 0] }

    }}
])

Now i want to update the value .How can I update?

Possible duplicate of Retrieve only the queried element in an object array in MongoDB collection — Bùi Đức Khánh
– Bùi Đức Khánh, Commented Dec 5, 2017 at 5:02
Might be but my value is not fixed in every document so i cannot match on the basis of give me those document where value=A. — TB.M
– TB.M, Commented Dec 5, 2017 at 5:06
Your requirement is about to ignore display items of array with blank value right ? — Bùi Đức Khánh
– Bùi Đức Khánh, Commented Dec 5, 2017 at 7:25

Bùi Đức Khánh · Accepted Answer · 2017-12-05 06:15:05Z

1

If your mongodb version higher than 3.2 you can using $filter for projection https://docs.mongodb.com/master/reference/operator/aggregation/filter/#exp._S_filter

Hope this help

        db.yourtable.aggregate([
        {$project: {
            "data.field.fields": {$filter: {
                                    input: '$data.field.fields',
                                    as: 'fields',
                                    cond: {$ne: ['$$fields.value', '']}
            }}
        }}
    ])

answered Dec 5, 2017 at 6:15

Bùi Đức Khánh

4,6987 gold badges32 silver badges46 bronze badges

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

Comments

tomups · Accepted Answer · 2017-12-05 15:25:23Z

0

db.collection.find({
    'data.field.fields': {
        $elemMatch: {
            value: 'A'
        }
    }
}, {
    'data.field.fields.$': 1
})

edited Dec 5, 2017 at 15:25

tomups

6,1652 gold badges25 silver badges28 bronze badges

answered Dec 5, 2017 at 6:50

Rubin Porwal

3,8451 gold badge27 silver badges27 bronze badges

1 Comment

TB.M Over a year ago

its matching perfectly only i want to see only "value" : "A" key value but with this other key values are also coming which is there in array.

Collectives™ on Stack Overflow

MongoDB: Find array element which having some value?

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related