How to use $addFields (aggregation) only when a certain condition is met

user_1007727 0
Viewed 1483

I'm trying to add field only when a certain condition is met, for example, if an array size > 0 then use $addFields to add field "date", otherwise don't add it.

  • when using $cond its a boolean so I have to add a field with either date value or false
  • When using if I have to provide else, then conditions

Any ideas on how to achieve this?

aggregation-framework mongodb
1 Answers

Starting in MongoDB 3.6, you can use the variable $$REMOVE in aggregation expressions to conditionally suppress a field. For an example, see Conditionally Exclude Fields,

  {
    $addFields: {
      date: {
        $cond: [
          { $gt: [{ $size: "$array" }, 0] },
          "date field", // your date field
          "$$REMOVE"
        ]
      }
    }
  }

Playground

user_89871280
Related