using $and with $match in mongodb

Question

I am trying to use the following query in MongoDB but it is not working.

  db.test.aggregate(
    $match: {
      $and: [
        type: { $in: ["TOYS"] },
        type: { $nin: ["BARBIE"] },
        time: { $lt: ISODate("2013-12-09T00:00:00Z") }
      ]
    }
  })

It says invalid character ":".

Is it possible to use $and with $match? I have seen an example on this forum of $or with $match so I presumed this is possible.

Thank you in advance for your help and guidance.

The documentation is here: docs.mongodb.org/manual/reference/operator/aggregation/match — Bud Damyanov
– Bud Damyanov, Commented Dec 9, 2013 at 11:44
Thanks for the reply. I gather that I do not need to use $and since it is implied in the query? — Manus
– Manus, Commented Dec 9, 2013 at 11:51
This is a query that works perfectly without aggregation framework, use a regular find — Max Rios
– Max Rios, Commented Dec 9, 2013 at 11:53
I agree with Maximiliano Rios, read this docs.mongodb.org/manual/reference/method/db.collection.find — Bud Damyanov
– Bud Damyanov, Commented Dec 9, 2013 at 11:55
Why suggest him to use something else, instead of helping to solve his problem? Maybe what we see is only a tiny part of his full aggregation? — Daniel W.
– Daniel W., Commented Feb 14, 2017 at 11:31

4J41 · Accepted Answer · 2015-10-14 05:59:20Z

118

$and with $match works just fine.

You have syntax errors in your query. Try this.

db.test.aggregate([
                   { 
                     $match: {
                          $and: [ 
                              {type: {$in: ["TOYS"]}}, 
                              {type: {$nin: ["BARBIE"]}}, 
                              {time: {$lt:ISODate("2013-12-09T00:00:00Z")}}
                          ]
                     }
                   }
                  ])

And for what you are trying to do, you do not need an $and.

edited Oct 14, 2015 at 5:59

answered Dec 9, 2013 at 12:41

4J41

5,1051 gold badge31 silver badges43 bronze badges

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

5 Comments

Manus Over a year ago

Hi Ajai.....thanks for the correction. And yes I found out that $and is not required. Thank you to all for helping me out.

Doguhan Uluca Over a year ago

Isn't the use $and redundant in this case? At least in MongoDB 3.2+ it seems to be.

4J41 Over a year ago

Yes. $and is redundant here.We have it to answer the question: Is it possible to use $and with $match?

Gene M Over a year ago

I don't think $and is entirely redundant within $match... Maybe in the most simple cases... First I tried two separate $expr conditions directly within $match, but was not getting the proper result... Had to add the $and in order to combine the comparisons properly (version 3.6.2).

Zitoun Over a year ago

In the case where you build the matching expression sequentially and have several conditions on the same parameter, using $and in the $match expression can be pretty convenient.

alfonsoolavarria · Accepted Answer · 2016-06-15 19:37:58Z

9

{
  $match: {
    $or:[
      {'sender':sender, 'recipient':recipient},
      {'recipient':sender,'sender':recipient}
    ]
  }
}

using $or

answered Jun 15, 2016 at 19:37

alfonsoolavarria

1,22512 silver badges11 bronze badges

Comments

KOGI · Accepted Answer · 2021-05-19 22:23:38Z

9

db.test.find( {$and: [ {"type": {$in: ["TOYS"]}}, 
                       {"type": {$nin: ["BARBIE"]}}, 
                       {"time": {$lt:ISODate("2013-12-09T00:00:00Z")}}
                     ]
})

AND works with FIND, receives an array of matches (but it's not a match instruction) Aggregation framework is for something completely different, it's like the word says, for aggregating (count, sum, avg, and so worth grouping or unwinding, etc)

edited May 19, 2021 at 22:23

KOGI

3,9992 gold badges26 silver badges38 bronze badges

answered Dec 9, 2013 at 12:11

Max Rios

2,2562 gold badges21 silver badges37 bronze badges

3 Comments

Manus Over a year ago

Thanks for the answer Maximiliano. I used an aggregation because I needed to group by userID after matching these records. Sorry for giving an incomplete picture of the problem. So I gather $and is not possible with aggregation then....

Max Rios Over a year ago

You can use $and with aggregation but you don't have to write it, and is implicit using different filters, in fact you can pipe those filters in case one of them needs a different solution.

J.Wells Over a year ago

$match takes { <query> }. That means, it can take $and just fine.

Rafiq · Accepted Answer · 2022-02-22 22:59:42Z

1

example of $lookup then $match

db.orders.aggregate([
  {
    "$lookup": {
      "from": "user",
      "localField": "user",
      "foreignField": "_id",
      "as": "user"
    }
  },
  {
    "$unwind": "$user"
  },
  {
    "$match": {
      "$and": [
        {
          "privacy.mode": {
            "$gt": 0
          }
        },
        {
          "user.privacy.mode": {
            "$gt": 0
          }
        }
      ]
    }
  }
])
``

answered Feb 22, 2022 at 22:59

Rafiq

12k5 gold badges44 silver badges46 bronze badges

Collectives™ on Stack Overflow

using $and with $match in mongodb

4 Answers 4

5 Comments

Comments

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

5 Comments

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related