0
249
ViewsMongodb $min value is greater than $max sometimes
I'm fetching date from mongo database and returns $first,$max, $min, and $last, however something very unusual happens - $min is greater than $max. Here's my code:
let Lowestdate = await ETHMongo.aggregate([
{
$match: { createdAt: { $gte: new Date(last), $lte: new Date(NEW) } },
},
{
$group: {
_id: null,
minFee_doc: { $first: "$$ROOT" },
minFee: { $min: "$one" },
firstFee: { $first: "$one" },
lastFee: { $last: "$one" },
maxFee: { $max: "$one" },
},
},
]).then((result) => {});
Any solution?
·
Juan Pablo Isaza
1 answers
Answer question0
It looks like your "numbers" are saved as string, in string comparison "99" > "1000000".
Luckily you can solve this very easily, just cast the string to number using $toInt
{
$group: {
_id: null,
minFee_doc: { $first: "$$ROOT" },
minFee: { $min: {$toInt: "$one"} },
firstFee: { $first: "$one" },
lastFee: { $last: "$one" },
maxFee: { $max: {$toInt: "$one"} },
},
}
·
Juan Pablo Isaza
Report
Answer question