使用節點和貓鼬試圖獲取從集合中的欄位資料日子是有負存盤以及正數。我只想以正數顯示所有天數資料,因此使用Math abs函式。但不知何故它不起作用,也沒有顯示任何錯誤。
代碼如下:
let projection = {
_id : 0,
userId : 1,
sum : 1,
days : Math.abs("$days"), //This is not working
leaveType : 1,
reason : 1,
fromDate : 1,
toDate : 1,
leaveDuration : 1,
leaveStatus : 1,
createdAt : 1,
updatedAt : 1,
rejectReason : 1,
empName : "$userDetails.fullName",
leaveType : "$LeaveDetails.leaveTitle",
availableBalance : 1,
}
uj5u.com熱心網友回復:
$abs (aggregation)就是你要找的。鏈接:https : //docs.mongodb.com/manual/reference/operator/aggregation/abs/
let projection = {
_id : 0,
userId : 1,
sum : 1,
days: {$abs: "$days" } , //This will work
leaveType : 1,
reason : 1,
fromDate : 1,
toDate : 1,
leaveDuration : 1,
leaveStatus : 1,
createdAt : 1,
updatedAt : 1,
rejectReason : 1,
empName : "$userDetails.fullName",
leaveType : "$LeaveDetails.leaveTitle",
availableBalance : 1,
}
轉載請註明出處,本文鏈接:https://www.uj5u.com/caozuo/352589.html
標籤:javascript 节点.js MongoDB 猫鼬
上一篇:在v9中洗掉集合firebase
