Articles → MONGODB → $Expr Operator In Mongodb

$Expr Operator In Mongodb

In this article, we will discuss the $expr operator in MongoDB.

Purpose

The $expr operator is used to compare fields in the same document.

Consider the following collection: -

The requirement is to find the documents where the spent is more than the budget. So, the query would be: -

db.mycollection.find({
  $expr: {
    $gt: ["$spent", "$budget"]
  }
})

Query/Feedback