Mongoose find check null coalesce on nested object in an array

Question

I have a model like this:

var organization = new Schema({
  things:[
    {a:{
      b:string
      }
    }
  ]
})

And I am trying to findOne with Mongoose like this:

let organization = await Organization.findOne({
  "things.a.b": "uniquestring",
});

But the problem is that a may be null.

I would like to do something like this:

let organization = await Organization.findOne({
  "things.a?.b": "uniquestring",
});

Is there a way to check for null on this query?

Shivam · Accepted Answer · 2022-03-22 14:15:51Z

1

I'm not sure if this answers your question, but can't you do something like this. If you think your only issue is there may be some null objects

Assuming your object looks like this

[
  {
    "things": [
      {
        "a": {
          "b": "test"
        }
      },
      {
        "a": null
      },
      {
        "a": {
          "b": "abc"
        }
      }
    ]
  }
]

Then you can run this query

db.collection.find({
  things: {
    "$elemMatch": {
      "a.b": "test"
    }
  }
},
{
  "things.$": 1
})

You can check MongoDB playground here

answered Mar 22, 2022 at 14:15

Shivam

3,6622 gold badges15 silver badges30 bronze badges

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

Collectives™ on Stack Overflow

Mongoose find check null coalesce on nested object in an array

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