Mongodb Mongoose 排除数组中包含特定嵌套对象的文档

这是一个相当简单的发现.想象一下，您want要查找具有matchingHistory的文档，该文档的数组中有一个与{ color: 'red', shape: 'square', size: 'large'}匹配的对象，然后按如下方式求反:

Mongosh Shell个

db.collection.find({
  $or: [
    {
      matchingHistory: {
        $exists: true,
        $eq: []
      }
    },
    {
      matchingHistory: {
        $exists: false
      }
    },
    {
      matchingHistory: {
        $not: {              //< All important not
          $elemMatch: {      //< Exact element match
            color: "red",
            shape: "square",
            size: "large"
          }
        }
      }
    }
  ]
}, {'matchingHistory._id': 0, 'matchingHistory.updatedAt': 0 });

Node Driver:个

db.collection.find({
  $or: [
    {
      matchingHistory: {
        $exists: true,
        $eq: []
      }
    },
    {
      matchingHistory: {
        $exists: false
      }
    },
    {
      matchingHistory: {
        $not: {              //< All important not
          $elemMatch: {      //< Exact element match
            color: "red",
            shape: "square",
            size: "large"
          }
        }
      }
    }
  ]
}).project({
   'matchingHistory._id': 0, 
   'matchingHistory.updatedAt': 0 
});