Count array elements that matches condition

by

You need to use $filter aggregation to filter out the external origin and internal origin along with the $size aggregation to calculate the length of the arrays.

Something like this

db.collection.aggregate([
  { "$addFields": {
    "internalUsersCount": {
      "$size": {
        "$filter": {
          "input": "$participants",
          "as": "part",
          "cond": { "$eq": ["$$part.origin", "internal"]}
        }
      }
    },
    "externalUsersCount": {
      "$size": {
        "$filter": {
          "input": "$participants",
          "as": "part",
          "cond": { "$eq": ["$$part.origin", "external"] }
        }
      }
    }
  }}
])

Output

[
  {
    "conferenceName": "myFirstConference",
    "endDate": 1535722420,
    "externalUsersCount": 1,
    "internalUsersCount": 1,
    "startDate": 1535722327
  }
]

More Related Contents:

  1. Mongodb aggregation $group, restrict length of array
  2. Retrieve only the queried element in an object array in MongoDB collection
  3. Update MongoDB field using value of another field
  4. Get names of all keys in the collection
  5. How to filter array in subdocument with MongoDB [duplicate]
  6. MongoDB: Combine data from multiple collections into one..how?
  7. $lookup multiple levels without $unwind?
  8. How to remove a field completely from a MongoDB document?
  9. Multiple join conditions using the $lookup operator
  10. Conditional $sum in MongoDB
  11. MongoError: The ‘cursor’ option is required, except for aggregate with the explain argument
  12. exclude fields in $lookup aggregation
  13. Find duplicate records in MongoDB
  14. Add some kind of row number to a mongodb aggregate command / pipeline
  15. Mongo sort on a calculated condition
  16. MongoDB sort documents by array elements
  17. MongoDB: Calculate dwell time between every status value change
  18. MongoDB: how to parse date in 3.6 mongoDb version?
  19. Using stored JavaScript functions in the Aggregation pipeline, MapReduce or runCommand
  20. MongoDB – The argument to $size must be an Array, but was of type: EOO / missing
  21. $in requires an array as a second argument, found: missing
  22. convert iso date to timestamp in mongo query
  23. Remove Duplicates from MongoDB
  24. Using $slice operator to get last element of array
  25. How to access overall document count during arithmetic aggregation expression
  26. Mongodb aggregation pipeline how to limit a group push
  27. MongoDB: find and findOne with nested array filtering
  28. mongodb get _id as string in find query
  29. mongodb aggregate query isn’t returning proper sum on using $sum
  30. MongoDB aggregate within daily grouping [duplicate]

Leave a Comment