Sum toLong overflow error – Moralis
I’m trying to get sum of amounts using a cloud function but I receive overflow error.
I’m using $toLong and the amounts are kept in the database as string
{“code”:141,“error”:“Failed to parse number ‘15000000000000000000’ in $convert with no onError value: Overflow”}
here is the code:
Moralis.Cloud.define(“totalAmount”, async (request) => {
let query = new Moralis.Query(“PredictionsBet”);
const pipeline = [
{group: {objectId: ‘$address’, totalAmount:{$sum:{$toLong : ‘$amount’}}}}
];const result = query.aggregate(pipeline);
return result;
});
Read more here: Source link