/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

1 vote178 views1 answer
Challenges in agile
TypeScript
0 vote186 views1 answer
Products = product.object.all() python
TypeScript
0 vote178 views1 answer
Uat testing vs system testing
TypeScript
2 votes163 views1 answer
Cra template-typescript cmd
TypeScript
1 vote164 views1 answer
Vue components import each other recursive
TypeScript
0 vote170 views1 answer
Run an applescript
TypeScript
1 vote168 views1 answer
Ion input ngmodel not working ionic 6
TypeScript
5 votes169 views1 answer
Vscode change comments color
TypeScript
16 votes179 views1 answer
Python for with two arrays
TypeScript
56 votes262 views6 answers
Cannot be loaded because running scripts is disabled on this system.
TypeScript