MongoDB query for adding to array if not present

Question

I am new to MongoDB and want to know if there is any way to add an embedded document to an array if it is not present.

Let's say I have a collection called products:

{
    _id: "123",
    name: "Hair-Dryer",
    locations: [{
            code: "MA",
            name: "Massachusetts"
        },
        {
            code: "IL",
            name: "illinois"
        }
    ]
}, {
    _id: "456",
    name: "Toaster",
    locations: [{
        code: "MA",
        name: "Massachusetts"
    }, ]
}

Now lets say I want to add :

{
        code: "IL",
        name: "illinois"
}

To only those documents which don't have them. Note that, I don't know which documents have my required data or which don't have them. I need to find that out.

How can I write a query like this in MongoDB ?

Dheemanth Bhat · Accepted Answer · 2021-03-19 11:00:56Z

1

The $addToSet operator adds a value to an array unless the value is already present, in which case $addToSet does nothing to that array.

Try this:

db.locations.updateMany({}, {
    $addToSet: {
        locations: {
            code: "IL",
            name: "illinois"
        }
    }
});

edited Mar 19, 2021 at 11:00

answered Mar 19, 2021 at 10:50

Dheemanth Bhat

4,5022 gold badges30 silver badges43 bronze badges

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

Collectives™ on Stack Overflow

MongoDB query for adding to array if not present

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related