Mongoose query where value is not null

Question

Looking to do the following query:

Entrant
    .find
      enterDate : oneMonthAgo
      confirmed : true
    .where('pincode.length > 0')
    .exec (err,entrants)->

Am I doing the where clause properly? I want to select documents where pincode is not null.

Answer 1

You should be able to do this like (as you're using the query api):

Entrant.where("pincode").ne(null)

... which will result in a mongo query resembling:

entrants.find({ pincode: { $ne: null } })

A few links that might help:

• The mongoose query api
• The docs for mongo query operators