Mongodb find query based on an array field

Question

The collection:

{
         "_id" : ObjectId("57506d74c469888f0d631be6"),
         "name" : "mycollection",
         "details" : [ 
             {
                 "date" : "25/03/2020",
                 "number" : "A",
                 "active" : false
              }
        },
{
        "_id" : ObjectId("57506d74c469888f0d631usi"),
        "name" : "newcollection",
        "details" : [ 

            {
                "date" : "30/03/2020",
                "number" : "C",
                "active" : false
            } 
        },
{
        "_id" : ObjectId("57506d74c4633388f0d631usi"),
        "name" : "mycollection",
        "details" : [ 

            {
                "date" : "31/03/2020",
                "number" : "C",
                "active" : false
            }
        },
    }

The find query to get the values based on the active status inside the details field.

I have tried:

db.collection.find(
    {"name": "mycollection", "details": {"active": False}})

Expected result: I need the collections where the active is false under details field in each collection. For here record id ObjectId("57506d74c469888f0d631be6") and ObjectId("57506d74c4633388f0d631usi") should be displayed.

above query seems good to me or you can try this db.collection.find( {"name": "mycollection", "details.active": false}}) // case sensitive of boolean value — harshit kohli, May 27 '20 at 14:30
maybe related : https://stackoverflow.com/questions/3985214/retrieve-only-the-queried-element-in-an-object-array-in-mongodb-collection — Joseph Ireland, May 27 '20 at 14:44
like what if details array also contains some objects with active true and some with false you still require that document?@Navi — harshit kohli, May 27 '20 at 14:49
I want the documents which are active false only.@harshitkohli — Navi, May 27 '20 at 14:54

score 2 · Answer 1 · answered May 27 '20 at 15:50

2

If details array may have some objects with active = true, and some objects = false, and you need to get only the objects that have active = false, then we can use $filter in aggregation pipeline to filter the details array

your query maybe something like that

db.collection.aggregate([
  {
    $match: {
      name: "mycollection",
      "details.active": false
    }
  },
  {
    $project: {
      name: 1,
      details: {
        $filter: {
          input: "$details",
          as: "elem",
          cond: {
            $eq: ["$$elem.active", false]
          }
        }
      }
    }
  }
])

you can test it here

hope it helps

answered May 27 '20 at 15:50

Mohammed Yousry

2,134
1
5
7

Can you post it like group by active? – Navi May 28 '20 at 04:12
something like this? https://mongoplayground.net/p/77W3WbjBPqu – Mohammed Yousry May 28 '20 at 07:52
No, it is not @Mohammed – Navi May 28 '20 at 08:41
Could you explain how do you mean by group by active? – Mohammed Yousry May 28 '20 at 08:58

score 1 · Answer 2 · answered May 27 '20 at 14:38

The docs contain a section on this type of query here: https://docs.mongodb.com/manual/tutorial/query-array-of-documents/

Your query doesn't work because that syntax requires the array to contain that exact object, but documents in your array contain extra fields, so none match.

The query for this case is db.collection.find({"name": "mycollection", "details.active": False}).

Note: this will return all documents where the array contains objects with active==false, but it won't filter the actual arrays to remove any elements with active=true.

score 0 · Answer 3 · answered May 27 '20 at 15:10

The query for mongodb or robomongo is the same as in your case the find() might work, but I choose aggregate which could filter the values.

Example query:

db.getCollection('collection').aggregate([{$match: {'details.active': {$ne: true},"name":"mycollection"}}])

Simple. But kindly verify and revert.

Mongodb find query based on an array field

3 Answers3