MongoDB内嵌文档数组切片与指定字段投影实现方法问询

Hey there! I totally get where you're coming from—trying to combine array slicing and field projection in a single find query can feel frustrating since MongoDB doesn't let you do both directly on the same array field in the standard projection.

The solution here is to use MongoDB's aggregation framework, which gives you way more flexibility to manipulate arrays step-by-step. Here's how you can achieve both goals at once:

db.myCollection.aggregate([
  // First, target the exact document you're looking for (same as your find query)
  { $match: { "name": "test" } },
  // Then, project and transform the array
  {
    $project: {
      // Keep any top-level fields you need (like "name" here)
      name: 1,
      myArray: {
        // Step 1: Slice the array to get the first element (adjust the number as needed)
        $map: {
          input: { $slice: ["$myArray", 1] },
          as: "item",
          // Step 2: Extract only the "myField" from each sliced element
          in: { myField: "$$item.myField" }
        }
      }
    }
  }
])

Let me break this down into key points:

• The $match stage filters down to the document you want, just like your original findOne query.
• In the $project stage, we nest operations: first use $slice to get the subset of the array you need (in your example, the first 1 element). Then we wrap that sliced array in $map to iterate over each element and only keep the myField property.
• If you need to slice with an offset (like skip the first 2 elements and take the next 1), adjust the $slice parameters to match: { $slice: ["$myArray", 2, 1] } (this works just like JavaScript's array slice method).

One quick tip: unlike findOne, the aggregation framework returns a cursor. If you want a single document result, just chain .next() at the end of the aggregate call:

db.myCollection.aggregate([/* stages here */]).next()

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