How to convert null to string in aggregation?

Question

My collection Looks like this:

[
{
  "_id": {
    "$oid": "638ecf5247cf747bdd862bfb"
  },
  "title": "This is title one"
},
{
  "_id": {
    "$oid": "638ecf5247cf747bdd862bfb"
  },
  "title": null
},
{
  "_id": {
    "$oid": "638ecf5247cf747bdd862bfb"
  },
  "title": "This is title three"
}
]

But I want to convert every title that have null to string (not-found):

[
{
  "_id": {
    "$oid": "638ecf5247cf747bdd862bfb"
  },
  "title": "This is title one"
},
{
  "_id": {
    "$oid": "638ecf5247cf747bdd862bfb"
  },
  "title": "not-found" // null to be converted to string
},
{
  "_id": {
    "$oid": "638ecf5247cf747bdd862bfb"
  },
  "title": "This is title three"
}
]

How to convert null title to string for all documents that have null title?

nimrod serok · Accepted Answer · 2022-12-06 13:03:32Z

2

You can use a simple update:

db.collection.updateMany({
  "title": null
},
{
  $set: {
    title: "not-found"
  }
})

See how it works on the playground example

answered Dec 6, 2022 at 13:03

nimrod serok

16.1k2 gold badges15 silver badges36 bronze badges

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

3 Comments

dangarfield Over a year ago

You'll need to set {multi:true} for all docs.

nimrod serok Over a year ago

Only if you use update instead of updateMany

dangarfield Over a year ago

Good point! But your playground example won't use updateMany. I'm enjoying this speed game!

dangarfield · Accepted Answer · 2022-12-06 13:03:36Z

2

3 things:

Filter the items that you want to update {title:null}
$set the update to change the field value
Ensure that you can update multiple documents

Playground - https://mongoplayground.net/p/DfAWE1Swszb

db.collection.update({
  title: null
},
{
  $set: {
    title: "not-found"
  }
},
{
  multi: true
})

answered Dec 6, 2022 at 13:03

dangarfield

2,3501 gold badge15 silver badges18 bronze badges

Collectives™ on Stack Overflow

How to convert null to string in aggregation?

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related