How to Pull Out nested Objects in Mongodb?

Question

I'm trying to make a query by merging from another collection, but there are obstacles when the query is run, the data generated is not what I imagined

i have the data like this

{
        "_id": "5ce8981a46039c14a4ec32d1",
        "name": "Monkey D Luffy",
        "email": "[email protected]",
        "status": "not verified",
        "password": "$2a$10$ayluBIsOOelBTIk.69GjHubgQemr6dJfgBUELNusCOaUGLpS/qKs6",
        "metas": {
            "role": "admin",
            "smartphone": "ios",
            "address": "konoha",
            "hobby": "eat ramen"
        }
    },

and i want pull out metas from nested document :

{
        "_id": "5ce8981a46039c14a4ec32d1",
        "name": "Monkey D Luffy",
        "email": "[email protected]",
        "status": "not verified",
        "password": "$2a$10$ayluBIsOOelBTIk.69GjHubgQemr6dJfgBUELNusCOaUGLpS/qKs6",
        "role": "admin",
        "smartphone": "ios",
        "address": "konoha",
        "hobby": "eat ramen"
    },

if any duplicate from my question pls suggest me, because I didn't find the same question, mostly using arrays.

and here is my query:

db.accounts.aggregate([
    {
        $lookup: {
            from: "account_meta",
            localField: "_id", 
            foreignField: "account_id",
            as: "metas"
        }
    },

    { "$unwind": "$metas" },
    {
        $group: {
            _id: "$_id",
            name: {$first:"$name"},
            status: {$first: "$status"},
            email: {$first: "$email"},
            password: {$first: "$password"},
            data: {
                "$push": {
                    "k" : "$metas.key",
                    "v": "$metas.value"
                }
            }
        }
    },
    {
        $project: {
            "_id": "$_id", 
            "name": "$name", 
            "email": "$email", 
            "status": "$status", 
            "password": "$password",
            "metas" :{
                $arrayToObject: "$data"
            }
        }
    },
    {
        "$replaceRoot": {

            "newRoot":

                {
                    "$mergeObjects": [ {$arrayToObject: "$data"}, "$$ROOT"]
                },

        }
    },
])

solved xD i just change "$mergeObjects": [ '$metas', "$$ROOT"] and added $project : {metas: 0} after $replaceRoot — Heru Wijayanto
– Heru Wijayanto, Commented May 25, 2019 at 4:36
Please post answers as answers, not comments. Also, don't edit the question title; just mark the answer as "accepted". — melpomene
– melpomene, Commented May 25, 2019 at 5:10
Well, first you need to actually post an answer. Again, please stop editing your question; just post a separate answer. — melpomene
– melpomene, Commented May 25, 2019 at 5:51
As for accepting answers, see meta.stackexchange.com/questions/5234/…. You may have to wait two days to be able to accept your own answer. — melpomene
– melpomene, Commented May 25, 2019 at 5:55

melpomene · Accepted Answer · 2019-05-25 06:11:33Z

3

i just edit some code from my $mergeObject:

{
        "$replaceRoot": {

            "newRoot":

                {
                    "$mergeObjects": [ "$metas", "$$ROOT"]
                },

        }
},
{$project: { metas: 0} }

edited May 25, 2019 at 6:11

melpomene

86.2k8 gold badges97 silver badges156 bronze badges

answered May 25, 2019 at 6:02

Heru Wijayanto

4693 gold badges5 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

How to Pull Out nested Objects in Mongodb?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related