Mongoose -在子文档中按条件查找

const mongoose = require('mongoose');

// 定义子文档模型
const childSchema = new mongoose.Schema({
  name: String,
  age: Number
});

// 定义父文档模型
const parentSchema = new mongoose.Schema({
  children: [childSchema]
});

// 创建父文档并添加子文档
const Parent = mongoose.model('Parent', parentSchema);
const parent = new Parent({
  children: [
    { name: 'Alice', age: 10 },
    { name: 'Bob', age: 12 },
    { name: 'Charlie', age: 8 }
  ]
});

// 执行条件查询
const query = Parent.findOne({ 'children.age': { $gt: 10 } });

// 获取查询结果
query.exec((err, result) => {
  if (err) {
    console.error(err);
  } else {
    console.log(result);
  }
});