Mongodb Aggregate Help syntax error

Question

I need help in this aggregate,

db.billingcycles.aggregate([{
$project:{credit:{$sum:”$credits.value”},debt:{$sum: “debts.value”}},
}, {
$group:{_id:null,credits:{$sum:”$credit”},debt:{$sum:”$debt”}}
}])

Error: 2017-10-13T00:23:16.375-0300 E QUERY [thread1] SyntaxError: illegal character @(shell):2:23

Ravi Teja · Accepted Answer · 2017-10-13 05:03:11Z

1

try like this

db.billingcycles.aggregate([{
    $group: {
        "credit": {
            $sum: ”$credits.value”
        },
        "debt": {
            $sum: "$debts.value"
        }
    }
}, {
    $project: {
        "_id": null,
        "credit": 1,
        "debt": 1
    }
}]

answered Oct 13, 2017 at 5:03

Ravi Teja

6592 gold badges7 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

Mongodb Aggregate Help syntax error

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