Querying array in mongodb [duplicate]

Question

Kindly help me in the following scenario. Following is sample data single document. Among all document, I need single document, with array values as expected (status active, status other than active etc).

{
"_id":.......
"type":"dept",
"values":[
  {
    "name":"dept 1",
    "status":"active"
  },
  {
    "name":"dept 2",
    "status":"active"
  },
  {
    "name":"dept 3",
    "status":"deleted"
  },
  {
    "name":"dept 4",
    "status":"active"
  },
  {
    "name":"dept 5",
    "status":"active"
  },
  {
    "name":"dept 6",
    "status":"disabled"
  },
 ]
}

Expected Result

1) Get all Active (inside the array)

{
"_id":.......
"type":"dept",
"values":[
  {
    "name":"dept 1",
    "status":"active"
  },
  {
    "name":"dept 2",
    "status":"active"
  }
  {
    "name":"dept 4",
    "status":"active"
  },
  {
    "name":"dept 5",
    "status":"active"
  }
 ]
}

2) Get other than active (inside the array)

 {
  "_id":.......
  "type":"dept",
  "values":[

   {
     "name":"dept 3",
     "status":"deleted"
   },
   {
     "name":"dept 6",
     "status":"disabled"
    },
  ]
 }

Kindly help me querying in getting above expected result. I wand to retrive the document with the array value as expected in above example.

ganjim · Accepted Answer · 2018-10-11 08:08:51Z

1

you question has an answer here: How to search in array of object in mongodb

but in short you can do this:

db.collection.find({values: {$elemMatch: {status: 'active'}}})

hope it helps you

answered Oct 11, 2018 at 8:08

ganjim

1,4261 gold badge21 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

Querying array in mongodb [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related