我试图在最新的mongo 3.4.1服务器和3.4.1 shell中执行以下查询。
db.dealer.aggregate( [ {$match:{salesAreaId:{$in:[ObjectId("5858d03ec5109a098c854802")]}}}, {$lookup:{ from:"outstanding", localField:"_id", foreignField:"dealer_id", as:"outstandings" }}, {$filter:{ input:"$outstandings", as:"outstandings", cond:{ $is:{"$$outstandings.finalized":false} } }} ] )
但是它说
Error: command failed: { "ok" : 0, "errmsg" : "Unrecognized pipeline stage name: '$filter'", "code" : 40324, "codeName" : "Location40324" } : aggregate failed : _getErrorWithCode@src/mongo/shell/utils.js:23:13 doassert@src/mongo/shell/assert.js:13:14 assert.commandWorked@src/mongo/shell/assert.js:266:5 DBCollection.prototype.aggregate@src/mongo/shell/collection.js:1215:5 @(shell):1:1
根据说明,该文档 $filter
从v3.2开始支持。任何帮助。