How to count number of false values in an array mongo db query

Question

_id:5e4d18bd10e5482eb623c6e4
notification_obj:
 0  notification_text:"Welcome to the app and your account is created hello."
    open:false
    type:"just_click"

 1  notification_text:"Sebal started following you."
    open:true
    type:"open_profile"

 2  notification_text:"Hella started following you."
    open:false
    type:"open_profile"

So here I have an array 'notification_obj' array in a document of mongo database, I want to search the record with _id and in that record I want to count 'How many 'open:false' values are there. I want to count in this array that open:false how many times. Please help with a "query" in mongo db.

do a find query on the collection and then get the document/record and then do Array.filter and find the length of filtered array — saketh
– saketh, Commented Feb 22, 2020 at 2:57
How about some help with Aggregation function. I don't want to get the complete array from database. I want a query for mongo db. — Prateek Sharma
– Prateek Sharma, Commented Feb 22, 2020 at 3:02
Does this answer your question? Mongoose / MongoDB: count elements in array — technophyle
– technophyle, Commented Feb 22, 2020 at 3:04
@technophyle no this one is different. First I want to search the collection with _id and in that record I want to count number of true values in an array. — Prateek Sharma
– Prateek Sharma, Commented Feb 22, 2020 at 3:08
I know, but you can investigate the aggregate query in that answer and I believe you can achieve what you want with a small change. Hint: unwind. — technophyle
– technophyle, Commented Feb 22, 2020 at 3:08

Mayur Vaghasiya · Accepted Answer · 2020-02-22 05:45:10Z

4

I think this code help you.

db.getCollection('your_collection').aggregate([
  {
    $match: { _id: ObjectId("5a544.............") }
  },
  {
    $unwind: '$notification_obj'
  },
  {
    $match: { 'notification_obj.open': false }
  },
  {
    $count: 'total'
  }
]);

Output:

{
    "total" : 1
}

answered Feb 22, 2020 at 5:45

Mayur Vaghasiya

1,4812 gold badges18 silver badges27 bronze badges

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

1 Comment

Prateek Sharma Over a year ago

Had to change some things but this is the answer I was looking for thanks mayur.

Collectives™ on Stack Overflow

How to count number of false values in an array mongo db query

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related