MongoDB aggregate assert: command failed

Question

I use this query to find status( "isActive": false) true or false also find age depending on status last count total amount

db.programmershelper.aggregate([{
    $match: {
        "isActive": false
    }
}, {
    $group: {
        _id: "age",
        total: { $count: "$amount" } 
    }
}])

show this message as well assert: command failed: { "ok" : 0, "errmsg" : "unknown group operator '$count'", "code" : 15952, "codeName" : "Location15952" }

following error

aggregate failed
_getErrorWithCode@src/mongo/shell/utils.js:25:13

what is age here? and what is "amount"?

Naman
– Naman

2017-08-25 19:05:42 +00:00
Commented Aug 25, 2017 at 19:05 — Naman
– Naman, Commented Aug 25, 2017 at 19:05

Naman · Accepted Answer · 2017-08-25 19:08:43Z

1

You can follow the count, sum and average docs for group to find the exact solution per your requriements.

As to what I understood from the question , you want to aggregate based on filter "isActive": false and finding age depending on the last total count.

db.programmershelper.aggregate([{
    $match: {
        "isActive": false
    }
}, {
    $group: {
        _id: "age",
        count: { $sum: 1 }
    }
}])

answered Aug 25, 2017 at 19:08

Naman

32.8k32 gold badges240 silver badges385 bronze badges

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

Collectives™ on Stack Overflow

MongoDB aggregate assert: command failed

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related