How can I get specific field value with array nested filter in MongoDB?

Question

After I filtered nested array values then I added "$project" query for selecting specific fields.

I want to get "new_yn" field values outside of the nested array but I only got id and nested array values.

How can I fix my Query? Would you give me some guides? (MongoDB version is 5.0.6 Community)

[Query]

db.collection.aggregate([
  {
    $match: {
      "new_yn": "Y",
      "port_info": {
        $elemMatch: {
          "port_code": "http_https"
        }
      }
    }
  },
  {
    $project: {
      port_info: {
        $filter: {
          input: "$port_info",
          as: "item",
          cond: {
            $eq: [
              "$$item.port_code",
              "http_https"
            ]
          }
        }
      }
    }
  },
  {
    "$project": {
      "_id": 1,
      "new_yn": 1,
      "port_info.ip_port": 1
    }
  }
])

[Mongo Playground]

https://mongoplayground.net/p/OXOaz8ct4KA

Wow. Thank you for your help again! @nimrodserok I'm newbie in MongoDB. I think "$set" is only used in insert or update queries. — Bethlee
– Bethlee, Commented May 26, 2022 at 7:21

Dushyant Bangal · Accepted Answer · 2022-05-26 07:44:15Z

1

This is because you haven't included it in the first $project stage.

Just add new_yn:1 to the first project stage and it will work.

db.collection.aggregate([
  {
    $match: {
      "new_yn": "Y",
      "port_info": {
        $elemMatch: {
          "port_code": "http_https"
        }
      }
    }
  },
  {
    $project: {
      new_yn: 1,
      port_info: {
        $filter: {
          input: "$port_info",
          as: "item",
          cond: {
            $eq: [
              "$$item.port_code",
              "http_https"
            ]
          }
        }
      }
    }
  },
  {
    "$project": {
      "_id": 1,
      "new_yn": 1,
      "port_info.ip_port": 1
    }
  }
])

As suggested by Bethlee, you can use $set as well, but it will bring all other fields from that document, which I believe you dont want.

edited May 26, 2022 at 7:44

answered May 26, 2022 at 7:39

Dushyant Bangal

6,41310 gold badges54 silver badges86 bronze badges

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

1 Comment

Bethlee Over a year ago

Thank you for helping me and attaching detail description about the query.

Collectives™ on Stack Overflow

How can I get specific field value with array nested filter in MongoDB?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related