How check for exist and empty in mongoose by find function?

Question

I want to check some field for empty. the field can be null or not exist or empty array.

I did so far something does work but not cover when the "exist" or "null":

.find({ roles: { '$size': 0 } }, { projection: {} });

one important thing, it must start with .find({ roles: . so I can't use $or like in this answer. I need another solution for do it by pass a condition into roles object in find function.

Any ideas?

user_8987128 · Answer

You can try using $in, Playground

.find({
  roles: {
    $in: [null, 0, []]
  }
})

The not exist and null value only, you can try, Playground

.find({
  roles: null
})

How check for exist and empty in mongoose by find function?

1 Answers