Mongodb replace external id after $lookup

D0xzen — Mon, 11 Nov 2019 10:43:52 +0000

Hi, im going crazy...

I want to replace the userId inside the comments with the real user after the $lookup, i tried in many ways, i tried to group but i cant really reach what i want

This is my field inside the page collection:


"comments" : [
        {
            "user_Id" : ObjectId("aaa"),
            "content" : "aaaa",
            "rep" : [
                {
                    "user_Id" : ObjectId("bbb"),
                    "comment" : "bbbb",
                },
                {
                    "user_Id" : ObjectId("ccc"),
                    "comment" : "cccc",
                }
            ]
        },
        {
            "user_Id" : ObjectId("ddd"),
            "content" : "ddd",
            "rep" : [ ]
        }
    ]

Users collection:


"users" : [
        {
            "_id" : ObjectId("aaa"),
            "name" : "user1",
            "email" : "test1@test.com",
        },
        {
            "_id" : ObjectId("bbb"),
            "username" : "user2",
            "email" : "test2@test.com",
          }
]

What result i was looking for:


"comments" : [
        {
            "user" : {
                "_id" : ObjectId("aaa"),
                "name" : "user1",
                "email" : "test1@test.com",
                }
            "content" : "aaaa",
            "rep" : [
                {
                    "userId" : {
            "_id" : ObjectId("bbb"),
            "username" : "user2",
            "email" : "test2@test.com",
          },
                    "comment" : "bbbb",
                },
                {
                    "user" : {
                               "_id" : ObjectId("aaa"),
                               "name" : "user1",
                "email" : "test1@test.com",
                },
                    "comment" : "cccc",
                }
            ]
        },
        {
            "user" : {
            "_id" : ObjectId("bbb"),
            "username" : "user2",
            "email" : "test2@test.com",
          },
            "content" : "ddd",
            "rep" : [ ]
        }
    ]

What i did so far:


db.pages.aggregate([
    { 
        $match: { _id: ObjectId('abcbc') }
    },
    {
        $project: {
            comments: 1,
        }
    },
    {
        $lookup:
            {
                from: 'users',
                localField: 'comments.user_Id',
                foreignField: '_id',
                as: 'users'
            }
    }
]).pretty()

Right now it gives me the correct users but it give me comments with all my comments and users with all matched users how can i replace the userId with the real user object inside rep too?
If i change inside the $lookup as into 'comments.user' it'll replace everything.

Node backend and api calls same project

D0xzen — Wed, 30 Oct 2019 07:57:39 +0000

Hi guys,

I fail to understand how after creating a BackEnd website with Node and Expressjs, if i want to make some functions async ex when someone like a post i want to call an API and return the response in json and append it to the html...

I can create a route and threat it as a API call or i have to create a new project where i use only API calls? it's seems wrong to me cause i want only to allow some functions async...

DEV Community: D0xzen

Mongodb replace external id after $lookup

Node backend and api calls same project