MongoDB query to add new element in array or update the element if one of attributes is not changed

Question

I have such document

{
    "_id" : "N4H7gYQwNXwTiEe62",
    "createdAt" : ISODate("2020-05-07T20:18:59.144Z"),
    "title" : "Two roads",
    "userId" : "CnugxoBWs4ox6vG2k",
    "awards" : [ 
        {
            "type" : "suggested",
            "place" : 1.0,
            "addedAt" : ISODate("2020-10-23T20:33:58.885Z")
        },
        {
            "type" : "voted",
            "place" : 3,
            "addedAt" : ISODate("2020-10-23T20:33:58.885Z")
        }
    ]
}

Is it possible to write a query which add a new element in "awards" if "type" is not exists (fexample: new type "removed"), or update if type exists already as "suggested" or "voted". I need to update "place" and "addedAt".

Tiya Jose · Accepted Answer · 2020-10-24 04:35:21Z

1

Query to add a new element in "awards" if particular "type" does not exist (fexample: new type "removed"):

db.collection.update({
  "awards.type": {
    "$ne": "removed"
  }
},
{
  "$addToSet": {
    "awards": {
      type: "removed"
    }
  }
},
{
  multi: true
})

MongoDB Playground

Query to update if type exists already as "suggested":

db.collection.update({
  "awards.type": "suggested"
},
{
  "$set": {
    "awards.$.place": 0 /* replace 0 with your value */
  }
},
{
  multi: true
})

MongoDB Playground

If you want to update multiple documents, make sure you add multi:true

edited Oct 24, 2020 at 4:35

answered Oct 24, 2020 at 4:24

Tiya Jose

1,43915 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

MongoDB query to add new element in array or update the element if one of attributes is not changed

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