MongoDB查询求助：无法对含数组的文档执行简单查询

Hey there! Let's walk through some common query scenarios and solutions based on your MongoDB document structure—since you mentioned running into issues with simple queries, I'll cover the most frequent use cases you might be trying.

First, let's restate your document structure for clarity (I'll clean up the truncated last comment a bit):

{
  "_id": 1,
  "Title": "Title 1",
  "Author": "Author 1",
  "Comments": [
    { "Id": "Comment1_Id", "User": "User 1", "Content": "Content 1" },
    { "Id": "Comment2_Id", "User": "User 2", "Content": "Content 2" },
    { "Id": "Comment3_Id", "User": "User 3", "Content": "Content 3" },
    { "Id": "Comment4_Id", "User": "User 4", "Content": "Content 4" },
    { "Id": "Comment5_Id", "User": "User 5", "Content": "Content 5" }
  ]
}

Common Query Scenarios & Solutions #

1. Find documents that contain a specific comment (e.g., from "User 2") #

If you want to pull up the entire document where at least one comment is from a specific user, you can target the nested array field directly:

db.yourCollectionName.find(
  { "Comments.User": "User 2" },
  { Title: 1, Author: 1, _id: 0 } // Optional: specify fields to return
)

This works because MongoDB automatically looks inside arrays when you query nested fields.

2. Return only the matching comments (not the entire array) #

If you don't need all comments—just the ones that match your criteria—use $elemMatch in the projection stage to filter the array:

db.yourCollectionName.find(
  { "Comments.User": "User 2" },
  {
    Title: 1,
    Author: 1,
    Comments: { $elemMatch: { User: "User 2" } }
  }
)

For more flexibility (like returning multiple matching comments), use the aggregation pipeline with $filter:

db.yourCollectionName.aggregate([
  { $match: { "_id": 1 } }, // First, target the specific document
  {
    $project: {
      Title: 1,
      Author: 1,
      MatchingComments: {
        $filter: {
          input: "$Comments",
          as: "comment",
          cond: { $eq: ["$$comment.User", "User 2"] }
        }
      }
    }
  }
])

3. Search for comments with specific content #

To find documents where any comment contains exact content:

db.yourCollectionName.find(
  { "Comments.Content": "Content 3" }
)

For fuzzy matching (e.g., any comment that includes the word "Content"), use a regex:

db.yourCollectionName.find(
  { "Comments.Content": { $regex: "Content", $options: "i" } }
)

The i option makes the match case-insensitive.

If you had a specific error or a more targeted query in mind, feel free to share the details and I can refine this further!

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