romainnorberg/mongo-queries.md

Created March 30, 2020 19:26

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/romainnorberg/e5712773029b21c5673cfc55070766e7.js"></script>
Save romainnorberg/e5712773029b21c5673cfc55070766e7 to your computer and use it in GitHub Desktop.

Raw

count & sort by subdocuments

db.Visitor.aggregate([
    {
        $project: {
            "n": { $size: "$history" }
        }
    }
    ,
    {
        $group: {
            "_id": "$_id",
            "alln": { $sum: "$n" }
        }
    },
    {
        $sort: { "alln": -1 }

    }
]);