Mongoose Unique values in nested array of objects

by

A unique index on an array field enforces that the same value cannot appear in the arrays of more than one document in the collection, but doesn’t prevent the same value from appearing more than once in a single document’s array. So you need to ensure uniqueness as you add elements to the array instead.

Use the $addToSet operator to add a value to an array only if the value is not already present.

Group.updateOne({name: 'admin'}, {$addToSet: {users: userOid}}, ...

However, if the users array contains objects with multiple properties and you want to ensure uniqueness over just one of them (uid in this case), then you need to take another approach:

var user = { uid: userOid, ... };
Group.updateOne(
    {name: 'admin', 'users.uid': {$ne: user.uid}}, 
    {$push: {users: user}},
    function(err, numAffected) { ... });

What that does is qualify the $push update to only occur if user.uid doesn’t already exist in the uid field of any of the elements of users. So it mimics $addToSet behavior, but for just uid.

More Related Contents:

  1. Push items into mongo array via mongoose
  2. E11000 duplicate key error index in mongodb mongoose
  3. Mongoose: findOneAndUpdate doesn’t return updated document
  4. Mongoose populate vs object nesting
  5. Stop Mongoose from creating _id property for sub-document array items
  6. Populate nested array in mongoose
  7. Why does mongoose always add an s to the end of my collection name
  8. Cannot overwrite model once compiled Mongoose
  9. Mongoose Schema hasn’t been registered for model
  10. add created_at and updated_at fields to mongoose schemas
  11. Mongoose findByIdAndUpdate not returning correct model
  12. Mongoose duplicate key error with upsert
  13. Mongoose (mongodb) batch insert?
  14. How can I use a cursor.forEach() in MongoDB using Node.js?
  15. Mongoose update without callback
  16. Model.find().toArray() claiming to not have .toArray() method
  17. How to fix ‘Error: querySrv EREFUSED’ when connecting to MongoDB Atlas?
  18. How to define object in array in Mongoose schema correctly with 2d geo index
  19. Difference between MongoDB and Mongoose
  20. How to get all count of mongoose model?
  21. How can I save multiple documents concurrently in Mongoose/Node.js?
  22. Mongoose: CastError: Cast to ObjectId failed for value “[object Object]” at path “_id”
  23. Model.find() returns empty in mongoose [duplicate]
  24. How do I increment a Number value in Mongoose?
  25. How to reference another schema in my Mongoose schema?
  26. Mongoose findOneAndUpdate and runValidators not working
  27. Populate a mongoose model with a field that isn’t an id
  28. Mongoose select fields to return from findOneAndUpdate
  29. mongoose recursive populate
  30. MongoDB $lookup vs Mongoose populate

Leave a Comment