CODEWITHSUNDEEP
mongodbcountelement
Aditya
Aditya

Reputation: 1

Count number of elements in MongoDB

I want to get the total count of elements in a MongoDB collection.

In the sample JSON from MongoDB collection, I need to take count of elements under tasks in all the batches throughout the MongoDB collections,

{
    "_id": "PROJECTNAME",
    "path": "/PROJECTPATH/PROJECTNAME",
    "batches": {
        "Batch01": {
            "tasks": {
                "SHOT_ZBR_sh0060": {
                    "key": "value"
                },
                "ZBR_sh0100": {
                    "key": "value"
                }
            },
            "name": "Batch01"
        },
        "Batch02": {
            "tasks": {
                "SHOT_ZMI_sh0080": {
                    "key": "value"
                },
                "SHOT_ZMI_sh0030_combined": {
                    "key": "value"
                },
                "SHOT_ZMI_sh0010": {
                    "key": "value"
                }
            },
            "name": "Batch02"
        },
        "Batch03": {
            "tasks": {
                "SHOT_ZMI_sh0130": {
                    "key": "value"
                }
            },
            "name": "Batch03"
        }
    },
    "name": "PROJECTNAME"
}

Upvotes: 0

Views: 236

Answers (1)

shivshankar
shivshankar

Reputation: 2135

better to define tasks and batches as array to easy calculate using count. otherwise go throught plain javascript to count 

//let obj = your object
tasksCount=0
Object.keys(obj.batches).forEach(v=>{
    tasksCount+=Object.keys(obj.batches[v].tasks).length
})
console.log(tasksCount)

Upvotes: 1

Related Questions