How can I specific array values as out as given below?

Viewed 16

I was get an result of aggregate query from collection using $facet and $group aggregate but our development team does not satisfies with this result they are asked result must not be an objects given end

{
    "_id" : ObjectId("6316e1b9a9ac1f9acceaf488"),
    "status_counts" : [ 
        {
            "_id" : {
                "status" : "Closed"
            },
            "count" : 59662.0
        }, 
        {
            "_id" : {
                "status" : "Open"
            },
            "count" : 695.0
        }, 
        {
            "_id" : {
                "status" : "Pending"
            },
            "count" : 4039.0
        }
    ],
    "Priority_counts" : [ 
        {
            "_id" : {
                "Priority" : "Escalated"
            },
            "count" : 4722.0
        }, 
        {
            "_id" : {
                "Priority" : "Low"
            },
            "count" : 11.0
        }, 
        {
            "_id" : {
                "Priority" : "High"
            },
            "count" : 1.0
        },
        {
            "_id" : {
                "Priority" : "Medium"
            },
            "count" : 1.0
        }
    ],
    "assigned" : [ 
        {
            "_id" : true,
            "count" : 4351.0
        }, 
        {
            "_id" : false,
            "count" : 383.0
        }
    ],
    "transfered" : [ 
        {
            "_id" : true,
            "count" : 245.0
        }
    ],
    "cc" : [ 
        {
            "_id" : true,
            "count" : 4.0
        }
    ]
}

===================================================================================

From the above document expected output as below.. can anyone suggest me please..

{
    "_id" : ObjectId("6316e1b9a9ac1f9acceaf488"),
    "status_counts" : [ 
        {
            "status" : "Closed",
            "count" : 59662.0
        }, 
        {
            "status" : "Open"
            "count" : 695.0
        }, 
        {
            "status" : "Pending"
            "count" : 4039.0
        }
    ],
    "Priority_counts" : [ 
        {
            "Priority" : "Escalated"
            "count" : 4722.0
        }, 
        {
            "Priority" : "Low"
            "count" : 11.0
        }, 
        {
            "Priority" : "High"
            "count" : 1.0
        },
        {
            "Priority" : "Medium"
            "count" : 1.0
        }
    ],
    "assigned" : [ 
        {
            "_id" : true,
            "count" : 4351.0
        }, 
        {
            "_id" : false,
            "count" : 383.0
        }
    ],
    "transfered" : [ 
        {
            "_id" : true,
            "count" : 245.0
        }
    ],
    "cc" : [ 
        {
            "_id" : true,
            "count" : 4.0
        }
    ]
}
0 Answers
Related