Mongoose sum $size of subdocuments array field

Question

I have a document like this

{
 _id:ObjectId,
 subdocuments:[{
     arrayField:[String]
  }]
}

How can I get the total length of arrayFields contained in my parent document? I can get the number of subdocuments with $size : "$subdocuments", but I need something like $size : "$subdocuments.arrayField"

Paul · Accepted Answer · 2021-12-09 13:05:16Z

1

What I ended up doing is using the $map operator like this

{
  $addFields:{
    myLength:{
       $sum:{
           $map: {
               input: "$subdocuments.arrayField",
               as: "iterator",
               in: { $size: "$$iterator" },
                },
            }
         }
       }
}

answered Dec 9, 2021 at 13:05

Paul

9862 gold badges8 silver badges25 bronze badges

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

Comments

parkourkarthik · Accepted Answer · 2021-12-07 18:55:22Z

0

I can't think of a better way, but this should work:

db.collections.aggregate(
    { $unwind: "$subdocuments" },
    { $project: {
                  "arrayFieldLength": { $strLenCP: "$subdocuments.arrayField"
                }
    });

answered Dec 7, 2021 at 18:55

parkourkarthik

8341 gold badge8 silver badges20 bronze badges

Collectives™ on Stack Overflow

Mongoose sum $size of subdocuments array field

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