如何为Mongoose中含引用的数组字段设置查询条件？

Since your User model has an array of Event ObjectIds (_events), here are the most common ways to query based on this array—whether you're filtering by specific event IDs or event properties like eventDate:

1. Find Users with a Specific Event ID in Their Array #

If you want to fetch all users linked to a particular event, you can directly match the event ID in the _events array:

const targetEventId = "60d21b4667d0d8992e610c85"; // Replace with your actual Event ID

User.find({ _events: targetEventId })
  .then(users => {
    console.log("Users linked to this event:", users);
  })
  .catch(err => console.error("Query error:", err));

Mongoose automatically handles matching the ObjectId in the array here—no extra operators are needed unless you're checking multiple IDs at once.

2. Find Users with Any Event Matching Criteria (e.g., Date Range) #

The User collection only stores Event IDs, not the actual event data. So you have two straightforward approaches to filter users based on event properties:

Option A: Two-Step Query (Simple & Efficient) #

First fetch the relevant Event IDs, then find users who have those IDs in their _events array:

// Step 1: Get all events that meet your criteria (e.g., after 2024-01-01)
Event.find({ eventDate: { $gte: new Date("2024-01-01") } })
  .select("_id") // Only fetch IDs to keep the query light
  .then(matchingEvents => {
    const eventIds = matchingEvents.map(event => event._id);
    
    // Step 2: Find users with any of these event IDs
    return User.find({ _events: { $in: eventIds } });
  })
  .then(users => {
    console.log("Users with recent events:", users);
  })
  .catch(err => console.error("Query error:", err));

Option B: Aggregation (Single Query) #

Use $lookup to join the User and Event collections, then filter directly in one query:

User.aggregate([
  // Join User collection with Event collection
  {
    $lookup: {
      from: "events", // Name of your Event collection (typically lowercase plural)
      localField: "_events",
      foreignField: "_id",
      as: "eventDetails" // New field containing joined event data
    }
  },
  // Filter users where at least one event matches the date condition
  {
    $match: {
      "eventDetails.eventDate": { $gte: new Date("2024-01-01") }
    }
  },
  // Optional: Specify which fields to include in results
  {
    $project: {
      name: 1,
      _events: 1,
      eventDetails: { eventDate: 1, instructions: 1 }
    }
  }
])
.then(users => {
  console.log("Users with recent events:", users);
})
.catch(err => console.error("Aggregation error:", err));

3. Find Users Where All Events Match Criteria #

If you want users whose all associated events meet a condition (e.g., no events before 2024-01-01), exclude users who have any events that don't match:

// Step 1: Get events that do NOT meet your criteria
Event.find({ eventDate: { $lt: new Date("2024-01-01") } })
  .select("_id")
  .then(oldEvents => {
    const oldEventIds = oldEvents.map(event => event._id);
    
    // Step 2: Find users with none of these old events
    return User.find({ _events: { $nin: oldEventIds } });
  })
  .then(users => {
    console.log("Users with only recent events:", users);
  })
  .catch(err => console.error("Query error:", err));

4. Populate & Filter Events Alongside User Query #

If you want to fetch a user and only populate their events that meet certain criteria (instead of all events), use populate() with a match option:

const userId = "60d21b4667d0d8992e610c86"; // Replace with your User ID

User.findById(userId)
  .populate({
    path: "_events",
    match: { eventDate: { $gte: new Date("2024-01-01") } }, // Filter populated events
    select: "eventDate instructions" // Only include specific Event fields
  })
  .then(user => {
    console.log("User with filtered events:", user);
  })
  .catch(err => console.error("Populate error:", err));

Note: If no events match the match condition, the _events array in the user object will be empty.

内容的提问来源于stack exchange，提问作者James