How to count each true element within cases in an array of objects in mongodb?

Question

I want to get the number of items that meet the true condition in the status field for every cases. for example: Document

Output:

{“user_id”: “4-389-739”,“case1”:0,“case2”:3,“case3”:1,“case4”:1 }

Please don't use images for code/data/errors/etc. Just include them in a code block. — rickhg12hs
– rickhg12hs, Commented Apr 10, 2022 at 12:27

Nakul Bharti · Accepted Answer · 2022-04-09 23:06:12Z

1

The user id part is not sure from where you are getting in document i believe you can figure it out but for help you out with counting the cases this might help you

      {
    $group: {
     
      "case1": {
        $sum: {
          $cond: [{ $in: [true, "$case1.status"] }, 1, 0]
        }
      },
"case2": {
        $sum: {
          $cond: [{ $in: [true, "$case2.status"] }, 1, 0]
        }
      }
    }
  }

you can generalize here and add as many conditioin as possible

edited Apr 9, 2022 at 23:06

answered Apr 9, 2022 at 22:59

Nakul Bharti

1119 bronze badges

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

1 Comment

Christian Over a year ago

user_id is included. you can find it at the end of the Document

Collectives™ on Stack Overflow

How to count each true element within cases in an array of objects 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