MongoDB aggregate order a nested object

Question

In a MongoDB aggerate, is it possible to to sort a nested object and keep it as an object instead of an $unwinded set of records.

EG. Take this collection:

"vehicles": [
  {
    "make": "ford",
    "VehicleImages": [
      {
        "image": "stuff5",
        "ShowOrder": 5
      },
      {
        "image": "stuff2",
        "ShowOrder": 2
      },
      {
        "image": "stuff3",
        "ShowOrder": 3
      },
      {
        "image": "stuff1",
        "ShowOrder": 1
      },
      {
        "image": "stuff4",
        "ShowOrder": 4
      }
    ]
  },
  {
    "make": "vahxhall",
    "VehicleImages": [
      {
        "image": "stuff2",
        "ShowOrder": 2
      },
      {
        "image": "stuff1",
        "ShowOrder": 1
      },
      {
        "image": "stuff4",
        "ShowOrder": 4
      },
      {
        "image": "stuff5",
        "ShowOrder": 5
      },
      {
        "image": "stuff3",
        "ShowOrder": 3
      }
    ]
  }
]

Is it possible to transform it into the following, where the VehicleImages object is ordered by ShowOrder:

    "vehicles": [
  {
    "make": "ford",
    "VehicleImages": [
      {
        "image": "stuff1",
        "ShowOrder": 1
      },
      {
        "image": "stuff2",
        "ShowOrder": 2
      },
      {
        "image": "stuff3",
        "ShowOrder": 3
      },
      {
        "image": "stuff4",
        "ShowOrder": 4
      },
      {
        "image": "stuff5",
        "ShowOrder": 5
      }
    ]
  },
  {
    "make": "vahxhall",
    "VehicleImages": [
      {
        "image": "stuff1",
        "ShowOrder": 1
      },
      {
        "image": "stuff2",
        "ShowOrder": 2
      },
      {
        "image": "stuff3",
        "ShowOrder": 3
      },
      {
        "image": "stuff4",
        "ShowOrder": 4
      },
      {
        "image": "stuff5",
        "ShowOrder": 5
      }
    ]
  }
]

Wernfried Domscheit · Accepted Answer · 2022-10-17 13:42:10Z

1

MongoDB version 5.2 introduced $sortArray operator:

db.collection.aggregate([
  {
    $set: {
      VehicleImages: {
        $sortArray: {
          input: "$VehicleImages",
          sortBy: { ShowOrder: 1 }
        }
      }
    }
  }
])

Mongo playground

answered Oct 17, 2022 at 13:42

Wernfried Domscheit

60.4k10 gold badges93 silver badges132 bronze badges

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

Collectives™ on Stack Overflow

MongoDB aggregate order a nested object

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related