从 Mongodb 中的对象数组中查找对象

Question

const Schema = new Schema({
    queueId: {
        type: String,
        required: true,
        index: {
            unique: true
        }
    },
    players: {
        type: [
            {
                ID: {
                    type: String,
                    required: true,
                    index: {
                        unique: true
                    },
                    default: 'null'
                },
                name: {
                    type: String,
                    required: true,
                    default: 'null',
                },
                queueId: {
                    type: String,
                    required: true,
                    default: 'null'
                }
            }
        ],
        required: true,
        default: []
    },
    isAvailable: {
        type: Boolean,
        required: true,
        default: true
    },
    isFull: {
        type: Boolean,
        required: true,
        default: false
    }
});

如何使用 findOne() 从 players 获取对象，这是一个数组

我目前正在尝试此代码，但它

const doc = await List.findOne({ players: { ID: 'id' } });

基本上返回 null players 是一个数组，我想从对象的players数组中查找ID并获取文档。

Answer 1

db.collection.find({
  "players.ID": "1"
},
{
  "players.$": 1
})

mongoplayground

---

db.collection.find({
  "players.ID": "1"
})

mongoplayground

---

db.collection.aggregate([
  {
    $match: {
      "players.ID": "1"
    }
  },
  {
    $unwind: "$players"
  },
  {
    $match: {
      "players.ID": "1"
    }
  }
])

mongoplayground