如何在 MongoDB 中使用主条件连接主详细信息表

Question

如何为此查询添加 xads 的条件？（经验：小伙子状态=1

）

db.xads.aggregate([
                {
                    $lookup: {
                        from: 'xaditems',
                        localField: '_id',
                        foreignField: 'masterId',
                        as: 'xadItems'
                    },
                }
              ]);

Answer 1

有效！谢谢迪拉吉·卡特卡尔

db.xads.aggregate([
                {
                 $match:{"status":1} 
                },
                {
                    $lookup: {
                        from: 'xaditems',
                        localField: '_id',
                        foreignField: 'masterId',
                        as: 'xadItems'
                    },
                }
              ]);

Answer 2

db.xads.aggregate([
                {
                 $match:{"status":1} //add you filters in match
                },
                {
                    $lookup: {
                        from: 'xaditems',
                        localField: '_id',
                        foreignField: 'masterId',
                        as: 'xadItems'
                    },
                }
              ]);