{
"Employee": {
"EmployeeData": {
"basePay": "1000",
"sumPayAmount": "2000"
}
}
},
{
"Employee": {
"EmployeeData": {
"basePay": "4000",
"sumPayAmount": "1000"
}
}
}
如何找到大于哪里的basePay檔案sumPayAmount？
uj5u.com熱心網友回復：
您需要$expr比較這兩個欄位。并確保在比較之前將值轉換為十進制/整數。
db.collection.find({
$expr: {
$gt: [
{
$toDecimal: "$Employee.EmployeeData.basePay"
},
{
$toDecimal: "$Employee.EmployeeData.sumPayAmount"
}
]
}
})
示例 Mongo Playground
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/431857.html
標籤：mongodb