How to rename the columnname in mongodb using node js

Question

I tried to map two collections its working fine but I have doubt in how to rename the column name using mongodb.

promotion collection

{ 
    "_id" : ObjectId("5cf7679a0b0bed2e7483b998"),   
    "group_name" : "Latest",   
    "products" : 
   [ObjectId("5cecc161e8c1e73478956333"),ObjectId("5cecc161e8c1e73478956334")]
}

product collection

{ 
    "_id" : ObjectId("5cecc161e8c1e73478956333"), 
    "product_name" : "bourbon"
},
{ 
    "_id" : ObjectId("5cecc161e8c1e73478956334"), 
    "product_name" : "bour"
}

mapping query

db.promotional.aggregate(
     [
        {
           $lookup: {
             from: "product",
             localField: "products",
             foreignField: "_id",
             as: "products"
                   }
        },  
        {
           $project :{products :{_id:0}}  
        }

     ]
)

I got output

{ 
    "_id" : ObjectId("5cf7679a0b0bed2e7483b998"),   
    "group_name" : "Latest",   
    "products" : 
     [
       {  
         "product_name" : "bourbon"
       },
       {  
       "product_name" : "bour"
       }
     ]
}

Expected output

{ 
    "_id" : ObjectId("5cf7679a0b0bed2e7483b998"),   
    "group_name" : "Latest",   
    "products" : 
     [
       {  
         "name" : "bourbon"
       },
       {  
       "name" : "bour"
       }
     ]
}

How to rename productname to name using mongodb

Ashh · Accepted Answer · 2019-06-07 05:53:59Z

1

You can $map over the products array and can change the fields name

db.promotional.aggregate([
  { "$lookup": {
    "from": "product",
    "localField": "products",
    "foreignField": "_id",
    "as": "products"
  }},
  { "$addFields": {
    "products": {
      "$map": {
        "input": "products",
        "as": "product",
        "in": {
          "name": "$$product.product_name"
        }
      }
    }
  }}
])

If you are using mongodb version 3.6 and above

db.promotional.aggregate([
  { "$lookup": {
    "from": "product",
    "let": { "products": "$products" },
    "pipeline": [
      { "$match": { "$expr": { "$in": [ "$_id", "$$products" ] } } },
      { "$project": { "name": "$product_name", "_id": 0 }}
    ],
    "as": "products"
  }}
])

edited Jun 7, 2019 at 5:53

answered Jun 7, 2019 at 5:20

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

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

3 Comments

Hari Smith Over a year ago

@Fanpark I want rename function using in within {$project:{products :{"$name":product_name}}} its working or not

Ashh Over a year ago

@HariSmith If it works then I would have probably answered that way. But it does not. It is an object structure {products :{"$name":product_name}} You cannot add key inside array with that.

Hari Smith Over a year ago

thank you its working fine.can you explain how its work

Collectives™ on Stack Overflow

How to rename the columnname in mongodb using node js

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related