MongoDB Aggregate - Calculate total number of all nested array elements within an object

Question

I have a database structure which includes the following object:

"reactions": {
    "👊": [
        "5f3c569e70441a0017511fe2",
        "5f88d49dbf1b850017e28f4e",
        "5f488189b0c5970017aa8c7a"
    ],
    "😋": [
        "5f539086cfb52a00176089ed"
    ]
}

I want to be able to count the "number of reactions" (a total of all the nested elements) - so in this case, the expected result would be 4.

I tried the following, and this successfully counts the number of keys - the result is 2, but not the total number of values - which should be 4.

db.collection("posts").aggregate([{
    {
        $addFields: {
            reactionsArray: {
                $objectToArray: "$reactions"
            }
        }
    },
    {
        $addFields: {
            numberOfReactions: {
                $sum: {
                    $size: "$reactionsArray.v"
                }
            }
        }
    }
])

matthPen · Accepted Answer · 2020-10-18 16:45:35Z

2

Use $reduce to sum size of each element of your array.

db.collection.aggregate([
  {
    $addFields: {
      reactionsArray: {
        $objectToArray: "$reactions"
      }
    }
  },
  {
    "$project": {
      reactionsSize: {
        $reduce: {
          input: "$reactionsArray",
          initialValue: 0,
          in: {
            "$add": [
              "$$value",
              {
                $size: "$$this.v"
              }
            ]
          }
        }
      },
      
    },
    
  }
])

MongoDB Playground

answered Oct 18, 2020 at 16:45

matthPen

4,3731 gold badge18 silver badges18 bronze badges

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

Comments

Tiya Jose · Accepted Answer · 2020-10-18 04:06:38Z

1

You have to $unwind reactionsArray and then use $group to get total count

db.collection.aggregate([
  {
    $addFields: {
      reactionsArray: {
        $objectToArray: "$reactions"
      }
    }
  },
  {
    $unwind: "$reactionsArray"
  },
  {
    $group: {
      _id:"$_id",
      numberOfReactions: {
        $sum: {
          $size: "$reactionsArray.v"
        }
      }
    }
  }
])

MongoDB Playground

edited Oct 18, 2020 at 4:06

answered Oct 18, 2020 at 3:45

Tiya Jose

1,43915 silver badges25 bronze badges

Collectives™ on Stack Overflow

MongoDB Aggregate - Calculate total number of all nested array elements within an object

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related