How do you negate a $match aggregate in mongodb

Question

I have the following query that I need to find the reverse.

db.contracts.aggregate([ 
    { $match: { currentBalance: { $gt: 0 }, status: 'open' } }, 
    { $project: { customer_id: 1, lastTransactionDate: 1, currentBalance: 1, status: 1 } }
])

I an trying not to use

$or: [ currentBalance: { $ne: 0 }, status: { $ne: 'open' } ]

What I would really like is to use $not: [ condition ] as I will have more difficult aggregations to write. However I cannot find the right syntax. Any help appreciated. I am using mongodb 3.0.7

Please put some effort into properly tabbing your queries next time. They are super hard to read otherwise — David says Reinstate Monica
– David says Reinstate Monica, Commented Nov 26, 2015 at 17:10
Why are you trying not to use $ne? Is your condition going to be an array? If so, use $nin docs.mongodb.org/manual/reference/operator/query/nin — ʰᵈˑ
– ʰᵈˑ, Commented Nov 26, 2015 at 17:11
See also: docs.mongodb.org/manual/reference/operator/aggregation/not — David says Reinstate Monica
– David says Reinstate Monica, Commented Nov 26, 2015 at 17:15
This was just an example of a query I needed today. I know that in the future I will encounter much more difficult queries to negate and I know by experience that sometimes expressing a query straightforward and then checking for its opposite is easier and faster that reversing the truth of each operator and operand. So if I want to $notmatch how would I write it in mongo query? — Pascal DeMilly
– Pascal DeMilly, Commented Nov 28, 2015 at 4:01

Amr Saber · Accepted Answer · 2020-08-17 01:16:18Z

18

I think this is essentially what you mean (apologies if $not)

db.contracts.aggregate([
  {
    $match: {
      currentBalance: { $not: { $gt: 0 } },
      status: { $not: { $eq: 'open' } },
    },
  },

  {
    $project: {
      customer_id: 1,
      lastTransactionDate: 1,
      currentBalance: 1,
      status: 1
    }
  }
])

edited Aug 17, 2020 at 1:16

Amr Saber

1,06312 silver badges30 bronze badges

answered Feb 25, 2019 at 18:11

davidhilton68

3312 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

igmrrf · Accepted Answer · 2023-01-04 19:05:37Z

0

db.contracts.aggregate([ 
    { $match: { 
         currentBalance: 0, 
         status: { 
             $not: { 
                 $regex: 'open' 
             }
         }
     }
   }, 
   { $project: {
         customer_id: 1, 
         lastTransactionDate: 1, 
         currentBalance: 1, 
         status: 1 
     }
   }
])

edited Jan 4, 2023 at 19:05

answered Oct 24, 2022 at 9:28

igmrrf

5695 silver badges15 bronze badges

Collectives™ on Stack Overflow

How do you negate a $match aggregate in mongodb

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related