/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 vote109 views1 answer
Mongodb more 20 documents
TypeScript
1 vote65 views2 answers
How to install typescript globally npm
TypeScript
4 votes109 views2 answers
Wht we need migrationts in django
TypeScript
0 vote121 views1 answer
Pull rewuests in local project
TypeScript
-2 votes117 views1 answer
How to randomly generate a string in ts
TypeScript
0 vote121 views1 answer
Ignore hosts option in network proxy in ubuntu 16.04
TypeScript
0 vote116 views1 answer
Add legends to y plots matplotlib
TypeScript
0 vote101 views1 answer
Angular TS2377
TypeScript
6 votes113 views1 answer
Check all existing virtial environments python mac
TypeScript
0 vote120 views1 answer
Whats is the use Notes.create(note) .then((data) => { res.send(data); }) .catch((err) => { res.status(500).send({ message: err.message || 'Some error occurred while create the Notes', }); });
TypeScript