How to query documents where value is not null in Mongoose

MongoDB provides the $ne operator to select documents where the field value is not equal to the specified value. It also includes documents that do not contain the field.

The following example demonstrates how you can use the $ne operator to find documents where the value of the role field is not null:

const mongoose = require('mongoose')
const { Schema } = mongoose

const User = mongoose.model(
  new Schema({
    name: String,
    role: String

const users = await User.find({ role: { $ne: null } })

There is another operator called $nin that selects the documents where the field value is not in the specified array or the field does not exist.

Here is how you can use $nin to find all users that are not admin and owner:

const users = await User.find({ role: { $nin: ['admin', 'owner'] } })

✌️ Like this article? Follow me on Twitter and LinkedIn. You can also subscribe to RSS Feed.

You might also like...

Digital Ocean

The simplest cloud platform for developers & teams. Start with a $200 free credit.

Buy me a coffee ☕

If you enjoy reading my articles and want to help me out paying bills, please consider buying me a coffee ($5) or two ($10). I will be highly grateful to you ✌️

Enter the number of coffees below:

✨ Learn to build modern web applications using JavaScript and Spring Boot

I started this blog as a place to share everything I have learned in the last decade. I write about modern JavaScript, Node.js, Spring Boot, core Java, RESTful APIs, and all things web development.

The newsletter is sent every week and includes early access to clear, concise, and easy-to-follow tutorials, and other stuff I think you'd enjoy! No spam ever, unsubscribe at any time.