我在MongoDB中有查询:
db.questions.aggregate([
{ $project: {
total: { $add: [ "$answear_false", "$answear_true" ] }
}},
{ $project: {
percent_true: {
$cond: [
{ $eq: [ "$total", null ] },
0 ,
{ $divide: [ "$answear_true", "$total" ] }
]
}
}},
{ $project: { _id: 1, total: 1, percent_true: 1 } }
])但结果打印不准确,结果上未显示字段合计
{ "_id" : "1004121032231110394769", "percent_true" : 0 }
{ "_id" : "1004121035679127802289", "percent_true" : 0 }
{ "_id" : "1004121038562570811362", "percent_true" : 0 }可以在一个查询中添加2个以上的$project吗?
发布于 2015-11-30 01:45:30
第二个项目过滤了total字段,尝试添加到第二个项目total:"$total“
https://stackoverflow.com/questions/33985865
复制相似问题