using $and with $match in mongodb

Question

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

db.test.aggergate(

$match: {$and: [type: {$in: ["TOYS"]}, type: {$nin: ["BARBIE"]}, time: 

{$lt:ISODate("2013-12-09T00:00:00Z")}]}})

The error is showing that ":" is an invalid character.

Can we use $and with $match?

Answer 1

There is a syntax error in your query. Try the following code:

db.test.aggregate([

                   { 

                     $match: {

                          $and: [ 

                              {type: {$in: ["TOYS"]}}, 

                              {type: {$nin: ["BARBIE"]}}, 

                              {time: {$lt:ISODate("2013-12-09T00:00:00Z")}}

                          ]

                     }

                   }

                  ])

If you are a beginner and want to know more about MongoDB then refer to the following MongoDB tutorial which will help you to learn MongoDB from scratch.

Learn about full stack web development by signing up for this professional Full Stack Training offered by Intellipaat..