Grouping results after $facet

Robert_Zefield · 2024-06-25T10:27:48.063Z

Hi there,

Suppose my $facet stage returns something like this:

{
  "messagesArray": [
  {
    "_id": 1,
    "messages": []
  },
  {
    "id": 2,
    "messages": ["Message1", "Message2"]
  },
  {
    "_id": 3,
    "messages": ["Message3"]
  }
  ],
  "objectsBought": [
  {
    "_id": 1,
    "bought": 10
  },
  {
    "_id": 2,
    "bought": 20
  }
  ],
  "objectsSold": [
  {
    "_id": 1,
    "sold": 20
  },
  {
    "_id": 3,
    "sold": 40
  }
  ]
}

What is the next stage to transform it into this ?

{[
{
  "_id":1,
  "messages":[],
  "bought": 10,
  "sold": 20
},
{
  "_id":2,
  "messages":["Message1", "Message2"],
  "bought": 20
},
{
  "_id":3,
  "messages":["Message3"],
  "sold": 40
}
]}

Any help or pointers highly appreciated

steevej · 2024-06-25T13:55:42.355Z

The simplest and probably the less efficient way is to $unwind the three arrays, extract the _id and then $group this _id.

The more complicated way would be with $map and $mergeObjects.

steevej · 2024-06-26T12:04:08.733Z

A third way is to leave it alone and to the final grouping in the application.

steevej · 2024-07-05T22:42:25.981Z

@Robert_Zefield, some follow up would be appreciated.