pipeline 管道复杂查询

pipeline 管道复杂查询

 var pipeline = PipelineDefinition<CargoSendList, CargoBillGroup>.Create(new[] {
                BsonDocument.Parse("{$match:{hzpm:'',dzhzzm:'',fzhzzm:''}}"),//查询条件
                BsonDocument.Parse("{$group:{_id:'$ysfs',lastDate:{$max:'$slrq'}}}"),//分组
                BsonDocument.Parse(@"{$lookup:{from:'youer-collection-name',let:{type:'$_id',lastDate:'$lastDate'},pipeline:[{$match:{$expr:{$and:[{$eq:['$ysfs','$$type']},{$eq:['$slrq','$$lastDate']}]}}},{$limit:1}],as:'data'}}"),
                BsonDocument.Parse("{$unwind:'$data'}"),
                BsonDocument.Parse("{$project:{_id:'$_id',lastDate:'$lastDate',data:'$data'}}")
            });