Nested Array search in MongoDB/PyMongo while using aggregate

Question

I am trying to search for a keyword inside array of arrays in a Mongo document.

{
  "PRODUCT_NAME" : "Truffle Cake",

  "TAGS": [
            ["Cakes", 100],
            ["Flowers", 100],
       ]
}

Usually, I would do something like this and it would work.

db.collection.find( {"TAGS":{"$elemMatch":{ "$elemMatch": {"$in":['search_text']} } }} )

But now, I changed this query to an aggregate based query due to other requirements. I've tried $filter , $match but not able to replicate the above query exactly..

Can anyone convert the above code so that it can directly work with aggregate? (I use PyMongo)

Tom Slabbaert · Accepted Answer · 2022-06-22 07:11:11Z

1

$match uses the same query syntax as the query language (find), from the docs:

The query syntax is identical to the read operation query syntax;

This means if you have a query that works in a "find", it will also work within a $match stage, like so:

db.collection.aggregate([
  {
    $match: {
      "TAGS": {
        "$elemMatch": {
          "$elemMatch": {
            "$in": [
              "Cakes"
            ]
          }
        }
      }
    }
  }
])

Check this live on Mongo Playground

answered Jun 22, 2022 at 7:11

Tom Slabbaert

22.5k10 gold badges34 silver badges45 bronze badges

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

3 Comments

Shubhang Kohirkar Over a year ago

Thank you so much, can't believe I missed that!

Shubhang Kohirkar Over a year ago

Very similar question, I believe you could help with that as well - stackoverflow.com/questions/72727058/…

Tom Slabbaert Over a year ago

sure, answered:)

Collectives™ on Stack Overflow

Nested Array search in MongoDB/PyMongo while using aggregate

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related