MongoDB aggregation - Match input parameter if provided else do not match

user_4036875 0
Viewed 1580

I have a MongoDB aggregation query in which I have the following:

{ $match: { version: versionNumber }

The 'versionNumber' is an optional input parameter to the aggreagation. If this versionNumber is not provided, then I do not want this match to be performed.

Currently, if the versionNumber is not supplied, the match still happens and I get a blank query output.

Is there a way in Mongo to do this? Thanks!

mongodb aggregation
2 Answers

There is a way to do that, yes, but it should be done in the application code. When building the pipeline array to pass to the query, only include the $match stage if the necessary information is provided.

var pipeline=[]
if (versionNumber) pipeline.push( {$match: {version: versionNumber }} )
pipeline.push( ... Other Stages ... )

db.collection.aggregate(pipeline)
user_22826340

I am not sure what will be the value in versionNumber when its not provided (optional), lets assume versionNumber will be any from "" or undefined or null,

  • if versionNumebr is not available then it will skip and when its available then it will match $eq condition
  • you can add more values in array [null, "", "undefined"], 0 zero or anything you wanted to skip
  {
    $match: {
      $expr: {
        $cond: [
          { $in: [versionNumber, [null, "", "undefined"]] },
          true,
          { $eq: ["$version", versionNumber] }
        ]
      }
    }
  }
  • if versionNumebr will be always single possible value "" then you can use $eq instead of $in,
  {
    $match: {
      $expr: {
        $cond: [
          { $eq: [versionNumber, ""] },
          true,
          { $eq: ["$version", versionNumber] }
        ]
      }
    }
  }

Playground

user_89871280
Related