How to push a field's value into another array field of same doc in MongoDB update

Question

I have one mongodb object like below :

{
    "_id" : ObjectId("5e54934b2dfddc1826223bbb"),
    "sellProducts" : {
        "products" : []
    },
    "sellServices" : {
        "services" : []
    },
    "categories" : [],
    "status" : "Published",
    "tags" : [],
    "dateRange" : [],
    "membershipRequired" : false,
    "usersAttending" : [],
    "cities" : [],
    "companies" : [ 
        ObjectId("5db1c84ec10c45224c4b95fd"),
    ],
    "companyId" : ObjectId("5db1c84ec10c45224c4b95fd"),
    "jobProfile" : [ 
        ObjectId("5e549339a3ad20c97b7b0c7d")
    ],
    "fundingBy" : []
}

Now I want to update the same record by pushing the value of the companyId field into the array of companies. How can I do that?

I tried below query but It didn't work :

db.getCollection('posts').update({_id: ObjectId("5e54934b2dfddc1826223bbb")},
    {
        $push: 
            {
                companies: "$$companyId"
            }
    })

@mehta-rohan, I update the question. It's companyId not a company. — Jay Sojitra
– Jay Sojitra, Commented Apr 16, 2020 at 17:32
Does this answer your question? Update MongoDB field using value of another field — whoami - fakeFaceTrueSoul
– whoami - fakeFaceTrueSoul, Commented Apr 16, 2020 at 17:34

whoami - fakeFaceTrueSoul · Accepted Answer · 2020-04-17 04:27:36Z

3

As you're using MongoDB version 4.2 where you can actually run aggregation pipeline in updates, Try below query :

/** As `$push` doesn't work in aggregation as update operator
 * You can use `$addFields` or `$set` to re-create 'companies' field by merging 'companies' array with array converted 'companyId' field
 * which would leave 'companies' as an array with existing elements + companyId */

db.getCollection('posts').updateOne({_id: ObjectId("5e54934b2dfddc1826223bbb")},
         [{$addFields : {companies: {$concatArrays: ['$companies',['$companyId']]}}}])

answered Apr 17, 2020 at 4:27

whoami - fakeFaceTrueSoul

18.1k6 gold badges35 silver badges51 bronze badges

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

2 Comments

Jay Sojitra Over a year ago

Thank you for your support. But when I execute your script it gives me below error: "Failed to execute script. Error: the update operation document must contain atomic operators Details:"

whoami - fakeFaceTrueSoul Over a year ago

@JaySojitra : In the past I’ve observed robo3T has issues using aggregation pipeline in updates especially with updateMany() & updateOne(), just try with update() !!

Collectives™ on Stack Overflow

How to push a field's value into another array field of same doc in MongoDB update

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related