Add field of array element in MongoDB aggregation

Question

I have a collection of documents containing an array of objects:

db.collection.insert({
    arr: [
      { id: 1, text: 'foo' },
      { id: 2, text: 'bar' },
    ]
});

Is there a way to extract/project/add a field of one element in that array? For example, the text field of the first element of the array. I've tried various variations of $addFields in MongoPlayground,

db.collection.aggregate([
  {
      $addFields: { text1: '$arr.text' }
  }
]);

but nothing produced just one text field. At best, I got both, with the syntax above, but I want only one field, in order to use $type on it, because it appears $type can't inspect array elements.

mickl · Accepted Answer · 2019-06-13 04:32:07Z

8

You can use $let with $arrayElemAt to define temporary variable and then reference it to get text field:

db.collection.aggregate([
    {
        $addFields: {
            text1: {
                $let: {
                    vars: {
                        first: {
                            $arrayElemAt: [ "$arr", 0 ]
                        }
                    },
                    in: "$$first.text"
                }
            }
        }
    }
])

answered Jun 13, 2019 at 4:32

mickl

50.1k9 gold badges71 silver badges99 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

rom Over a year ago

How do you add all the items by a specific key on the item/object and not just the first?

Dan Dascalescu · Accepted Answer · 2019-06-13 04:30:43Z

3

One way to extract a field of an array element is to project the first element using $arrayElemAt in a $project stage, then to access the desired field, e.g. text, in a second $project stage:

db.collection.aggregate([
  {
    $project: {
      elem1: {
        $arrayElemAt: ["$arr", 0]
      }
    }
  },
  {
    $project: {
      text1: "$elem1.text"
    }
  }
])

Mongo Playground.

answered Jun 13, 2019 at 4:30

Dan Dascalescu

154k66 gold badges336 silver badges422 bronze badges

Comments

Teharez · Accepted Answer · 2023-07-11 07:38:49Z

0

Another alternative I've found is using first and $getField which is new since Version 5.0

db.collection.aggregate([
  {
    $addFields: { 
      text1: {
        $getField: {
          field: 'text',
          input: { $first: '$arr' }
        }
      }
    }
  }
]);

edited Jul 11, 2023 at 7:38

answered Jul 11, 2023 at 7:26

Teharez

61511 silver badges30 bronze badges

Collectives™ on Stack Overflow

Add field of array element in MongoDB aggregation

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related