Count distinct MongoDb from array of values

Question

I have an array of distinct items -

search = alluk.distinct('Object of search')

I am looking to do a count for each item. Currently I am doing them manually like so -

alluk.find({'Object of search':'Offensive weapons'}).count()

Question

Is it possible to loop through the search array counting for each item in turn?

I have tried -

alluk.find({'Object of search':{'$in': search}}).count()

However this isn't exactly what I am after.

SOLUTION -

for item in alluk.aggregate([
  { '$match': { 'Object of search': { '$in': objectofsearch }}},
  { '$group': {
    '_id': '$Object of search',
    'count': { '$sum': 1 }
  }}
]):
    print(item)

Ashh · Accepted Answer · 2019-05-04 13:47:50Z

2

You can use $group aggregation to count the number of distinct counts

alluk.aggregate([
  { '$match': { 'Object of search': { '$in': search }}},
  { '$group': {
    '_id': '$Object of search',
    'count': { '$sum': 1 }
  }}
])

answered May 4, 2019 at 13:47

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

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

1 Comment

bsod_ Over a year ago

Thanks final solution added

Collectives™ on Stack Overflow

Count distinct MongoDb from array of values

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