How can I get a right query result in MongoDB (specially nested array)?

Question

I guessed when I run that MongoDB Query then I can get only filtered port_code 'http_https' data but it wasn't. All data is selected. How can I fix my Query? Would you give me some guides?

Query

{'port_info': {'$elemMatch': {'port_code': 'http_https'}}}

Documents

[{
  "_id": {
    "$oid": "6267a966fe9fa7f41d42d255"
  },
  "new_yn": "Y",
  "port_info": [
    {
      "ip_port": "199.20.93.164:80",
      "use_yn": "Y",
      "comment": "",
      "port_code": "http_https",
      "uri_info": [
        {
          "uri": "199.20.93.164/",
          "status_code": 404
        }
      ]
    },
    {
      "ip_port": "199.20.93.164:5985",
      "use_yn": "Y",
      "comment": "",
      "port_code": "http_https",
      "uri_info": [
        {
          "uri": "199.20.93.164:5985",
          "status_code": 200
        }
      ]
    },
    {
      "ip_port": "199.20.93.164:21 ",
      "use_yn": "Y",
      "comment": "",
      "port_code": "ftp"
    }
  ]
}]

nimrod serok · Accepted Answer · 2022-05-10 10:03:59Z

1

You can use a filter:

db.collection.aggregate([
  {
    $project: {
      port_info: {
        $filter: {
          input: "$port_info",
          as: "item",
          cond: {$eq: ["$$item.port_code", "http_https"]}
        }
      }
    }
  }
])

As you can see on this playground example

answered May 10, 2022 at 10:03

nimrod serok

16.1k2 gold badges15 silver badges36 bronze badges

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

3 Comments

Bethlee Over a year ago

Thank you for your help. How can I make those queries? I thought that project just for using get fields.

nimrod serok Over a year ago

I don't understand the question "How can I make those queries?" Can you clarify? $project is a way to format your documents. $filter is a way to format them.

Bethlee Over a year ago

Thank you for the explanation. I mean.. I'm struggling to make query in MongoDB. That's why wrote that sentence.

Collectives™ on Stack Overflow

How can I get a right query result in MongoDB (specially nested array)?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related