Query where not equal to null or empty

Question

I am trying to find all the documents where email exists.

I am trying the following find query:

{ "email": {$exists:true, $ne:null, $ne:""}}

Still I am getting documents where email is null.

Can anyone tell me what I am doing wrong?

Thanks a lot dude! It worked. Even i suspected the same thing as soon as i posted the question that it's somehow because of the two $ne. — Shreya Batra
– Shreya Batra, Commented Jul 10, 2017 at 8:44

Neil Lunn · Accepted Answer · 2017-07-10 08:36:53Z

74

You want $nin here:

.find({ "email": { "$nin": [ null, "" ] } })

The problem is $ne is repeated twice and overwrites. You could use $or but $nin is shorter:

Given:

{
    "_id" : ObjectId("59633c28f5f11516540d118e"),
    "a" : 1.0
}
{
    "_id" : ObjectId("59633c28f5f11516540d118f"),
    "a" : 1.0,
    "email" : ""
}
{
    "_id" : ObjectId("59633c28f5f11516540d1190"),
    "a" : 1.0,
    "email" : null
}
{
    "_id" : ObjectId("59633c28f5f11516540d1191"),
    "a" : 1.0,
    "email" : "fred"
}

Just returns:

{
    "_id" : ObjectId("59633c28f5f11516540d1191"),
    "a" : 1.0,
    "email" : "fred"
}

Also you do not also need $exists when you are actually testing a value. It's already implied that is does "exist".

answered Jul 10, 2017 at 8:36

Neil Lunn

151k36 gold badges356 silver badges327 bronze badges

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

Collectives™ on Stack Overflow

Query where not equal to null or empty

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