MongoDB update with condition

by

Starting Mongo 4.2, db.collection.update() can accept an aggregation pipeline, finally allowing the update/creation of a field based on another field:

// { a: "Hello", b: "World" }
// { a: "Olleh", b: "Dlrow" }
db.collection.updateMany(
  {},
  [ { $set: { active: { $eq: [ "$a", "Hello" ] } } } ]
)
// { a: "Hello", b: "World", active: true  }
// { a: "Olleh", b: "Dlrow", active: false }

  • The first part {} is the match query, filtering which documents to update (in our case all documents).

  • The second part [ { $set: { active: { $eq: [ "$a", "Hello" ] } } } ] is the update aggregation pipeline (note the squared brackets signifying the use of an aggregation pipeline). $set is a new aggregation operator and an alias of $addFields. Then any aggregation operator can be used within the $set stage; in our case a conditional equality check on which depends the value to use for the new active field.

More Related Contents:

  1. Possibility of duplicate Mongo ObjectId’s being generated in two different collections?
  2. How to remove a field completely from a MongoDB document?
  3. Store images in a MongoDB database
  4. MongoDB vs. Cassandra [closed]
  5. Find duplicate records in MongoDB
  6. Best practice to maintain a mgo session
  7. How do you rename a MongoDB database?
  8. Where does mongodb stand in the CAP theorem?
  9. How do I do a “NOT IN” query in Mongo?
  10. How do you query for “is not null” in Mongo?
  11. How to stop insertion of Duplicate documents in a mongodb collection
  12. Mongodb aggregation $group, restrict length of array
  13. Is mongodb running?
  14. Does MongoDB support floating point types?
  15. MongoDB normalization, foreign key and joining
  16. MongoDB Single Document size limit is 16MB
  17. Get a document in MongoDB without specifying collection
  18. MongoDB: Combine data from multiple collections into one..how?
  19. MongoDB: Is it possible to make a case-insensitive query?
  20. Mongoose and multiple database in single node.js project
  21. Multiple join conditions using the $lookup operator
  22. Aggregate $lookup Total size of documents in matching pipeline exceeds maximum document size
  23. Mongo complex sorting?
  24. MongoDB: update every document on one field
  25. How to sum every fields in a sub document of MongoDB?
  26. Does Mongoose support the Mongodb `findAndModify` method?
  27. MongoDB Text Search AND multiple search words
  28. What is the maximum number of parameters passed to $in query in MongoDB?
  29. Mongodb aggregation pipeline how to limit a group push
  30. MongoDB : aggregation framework : $match between fields

Leave a Comment