How to add array-index field to items in mongodb nested array

Question

Inspired by another question I was looking for a common way to add a field with the index to each item in a nested array.

Assuming my document looks like:

  {
    _id: ObjectId("5a934e000102030405000000"),
    events: [
      {
        status: 0,
        timestamp: ISODate("2022-05-29T13:26:00Z")
      },
      {
        status: 8,
        timestamp: ISODate("2022-05-29T14:41:00Z")
      },
      {
        status: 4,
        timestamp: ISODate("2022-05-31T10:13:00Z")
      },
      {
        status: 3,
        timestamp: ISODate("2022-05-31T10:18:00Z")
      }
    ]
  }

And I want each item to contain a new field which is the index of the item in the array:

{
    _id: ObjectId("5a934e000102030405000000"),
    events: [
      {
        arrayIndex: 0,
        status: 0,
        timestamp: ISODate("2022-05-29T13:26:00Z")
      },
      {
        arrayIndex: 1,
        status: 8,
        timestamp: ISODate("2022-05-29T14:41:00Z")
      },
      {
        arrayIndex: 2,
        status: 4,
        timestamp: ISODate("2022-05-31T10:13:00Z")
      },
      {
        arrayIndex: 3,
        status: 3,
        timestamp: ISODate("2022-05-31T10:18:00Z")
      }
    ]
  }

nimrod serok · Accepted Answer · 2022-12-27 21:11:43Z

0

Since mongoDB version 3.4, this can be done using an aggregation pipeline with a $reduce phase, which uses the size of the new accumulated array:

db.collection.aggregate([
  {$project: {
      events: {
        $reduce: {
          input: "$events",
          initialValue: [],
          in: {
            $concatArrays: [
              "$$value",
              [
                {$mergeObjects: [
                    "$$this",
                    {arrayIndex: {$size: "$$value"}}
                ]}
              ]
            ]
          }
        }
      }
  }}
])

See how it works on the playground example

edited Dec 27, 2022 at 21:11

answered Jul 1, 2022 at 20:29

nimrod serok

16.1k2 gold badges15 silver badges36 bronze badges

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

Collectives™ on Stack Overflow

How to add array-index field to items in mongodb nested array

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related