/TypeScript/Mongodb count based on array of ids

Mongodb count based on array of ids

Mongo count elements in array

> db.mycollection.insert({'foo':[1,2,3,4]})
> db.mycollection.insert({'foo':[5,6,7]})

> db.mycollection.aggregate([{$project: { count: { $size:"$foo" }}}])
{ "_id" : ObjectId("5314b5c360477752b449eedf"), "count" : 4 }
{ "_id" : ObjectId("5314b5c860477752b449eee0"), "count" : 3 }

Source: stackoverflow.com

Mongo count elements in array

{ $size: <expression> }

Source: docs.mongodb.com

Mongodb count based on array of ids

db.collection.aggregate([
    { $unwind: "$connects" },

    // count all occurrences
    { "$group": { "_id": {skill: "$skill", parser_id: "$connects.parser_id"}, "count": { "$sum": 1 } }},

    // sum all occurrences and count distinct
    { "$group": { "_id": "$_id.skill", "quantity": { "$sum": 1 } }},

    // (optional) rename the '_id' attribute to 'skill'
    { $project: { 'skill': '$_id', 'quantity': 1, _id: 0 } }
])

Source: stackoverflow.com

Similar codes

0 vote357 views1 answer
Css how to make a elements of same type start at same height
TypeScript
0 vote315 views1 answer
Non-abstract class does not implement inherited abstract member typescript
TypeScript
0 vote304 views1 answer
Primeng dropdown formControlName setValue
TypeScript
0 vote339 views1 answer
Typescript check if a value is undefined
TypeScript
1 vote302 views1 answer
Ionic copy to clipboard
TypeScript
0 vote295 views1 answer
Peer of typescript@>=2.8.0
TypeScript
0 vote334 views3 answers
Saving leaderstats script roblox
TypeScript
-1 vote363 views1 answer
Macro fiji bio-formats import options
TypeScript
0 vote315 views1 answer
Check runnong ports ubuntu
TypeScript
0 vote335 views2 answers
Check if a temporary table exists and delete if it exists
TypeScript