How to project only matched array item in mongodb aggregation?

Question

I have a collection called shows, with documents as:

       {
            "url": "http://www.tvmaze.com/shows/167/24",
            "name": "24",
            "genres": [
                "Drama",
                "Action"
            ],
            "runtime": 60
        },
        {
            "url": "http://www.tvmaze.com/shows/4/arrow",
            "name": "Arrow",
            "genres": [
                "Drama",
                "Action",
                "Science-Fiction"
            ],
            "runtime": 60
        }

I wanted to search shows with genre 'Action' and project the result array as

   {
        "url": "http://www.tvmaze.com/shows/167/24",
        "name": "24",
        "genres": [
            "Action" // I want only the matched item in 
         //my result array
        ],
        "runtime": 60
    } , //same for the second doc as well

If I use

db.shows.find({genres:'Action'}, {'genres.$': 1});

It works but the same does not work in aggregate method with $project

Shows.aggregate([
      {
        $match: { 'genres': 'Action'}
      },
      {
        $project: {
          _id: 0,
          url: 1,
          name: 1,
          runtime: 1,
          'genres.$': 1
        }
      }
]);

this is the error I get on this aggregate query

Invalid $project :: caused by :: FieldPath field names may not start with '$'."

The $ projection will work only on find methods, you can use $filter aggregation operator in aggregation query. — turivishal
– turivishal, Commented Jun 18, 2021 at 7:52
Does this answer your question? How to filter array in a mongodb query — turivishal
– turivishal, Commented Jun 18, 2021 at 8:00
@turivishal, no it did not answer, also what if I am using regex to match the genre 'Action', then how would I do it while projecting, it might not be the exact match. — Vinita
– Vinita, Commented Jun 18, 2021 at 8:07

Vinita · Accepted Answer · 2021-06-21 12:22:29Z

0

db.collection.aggregate([
  {
    $match: {
      "genres": {
        $regex: "/^action/",
        $options: "im"
      }
    }
  },
  {
    $project: {
      _id: 0,
      url: 1,
      name: 1,
      runtime: 1,
      genres: {
        $filter: {
          input: "$genres",
          as: "genre",
          cond: {
            $regexMatch: {
              input: "$$genre",
              regex: "/^action/",
              options: "im"
            }
          }
        }
      }
    }
  }
])

Here is how I solved it, Thanks @turivishal for the help

answered Jun 21, 2021 at 12:22

Vinita

1,8743 gold badges12 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

How to project only matched array item in mongodb aggregation?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related