'Add multiple values using $addToSet Mongo operator

$addToSet operator adds a value to an array only if the value is not already in the array. If the value is in the array, $addToSet does not modify the array.

I want to insert two values that should not be duplicated via one request. Is this possible?

I tried to pass an array to $addToSet operator but it inserted an array instead of each value from that array.

$ mongo test
MongoDB shell version: 2.4.9
connecting to: test
> db.c.insert({a: [1, 2, 3]})
> db.c.find()
{ "_id" : ObjectId("53511a255a82cd559393d840"), "a" : [ 1, 2, 3 ] }
> db.c.update({}, {$addToSet: {a: [2, 4]}})
> db.c.find()
{ "_id" : ObjectId("53511a255a82cd559393d840"), "a" : [ 1, 2, 3, [ 2, 4 ] ] }


Solution 1:[1]

From the docs for $addToSet:

If the value is an array, $addToSet appends the whole array as a single element. To add each element of the value separately, use $addToSet with the $each modifier. See Modifiers for details.

So you should use this instead:

db.c.update({}, {$addToSet: {a: {$each: [2, 4]}}})

Solution 2:[2]

Yep. But you need the $each modifier to be added in your statement:

db.c.update({},{ $addToSet: { a: {$each: [ 2, 4 ] } } })

And the result:

{ "a" : [ 1, 2, 3, 4 ] }

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 JohnnyHK
Solution 2 Neil Lunn