使用mongoose查询MongoDB中的内部数组状态

const mongoose = require('mongoose');
const { Schema } = mongoose;

// 定义用户模式
const userSchema = new Schema({
  name: String,
  orders: [
    {
      product: String,
      status: String
    }
  ]
});

const User = mongoose.model('User', userSchema);

// 查询所有包含状态为 'completed' 的订单的用户
User.find({ 'orders.status': 'completed' }, (err, users) => {
  if (err) return console.error(err);
  console.log(users);
});

userSchema.index({ 'orders.status': 1 });

User.aggregate([
  { $unwind: '$orders' },
  { $match: { 'orders.status': 'completed' } },
  { $group: { _id: '$_id', name: { $first: '$name' }, orders: { $push: '$orders' } } }
]).exec((err, users) => {
  if (err) return console.error(err);
  console.log(users);
});