How to push all set of record into one array using MongoDB query

Question

I need to push all records into one array while executing the mongoDB query. I am explaining my query below.

db.getCollection('orders').aggregate([
    {
        $match: {"Customer.StoreCode":"CMHB"}
    },
    {
        $group: {_id : "$Customer.CustomerMobile", "data" : {"$first" : "$$ROOT"}}
    },
    {
        $project: {
            OrderNumber:"$data.OrderNumber",
            OrderStatus:"$data.OrderStatus",
            OrderType:"$data.OrderType",
            CreatedAt:"$data.CreatedAt",
            CustomerMobile: "$data.Customer.CustomerMobile",
            CustomerLastName:"$data.Customer.CustomerLastName",
            CustomerFirstName:"$data.Customer.CustomerFirstName",
            StoreCode:"$data.Customer.StoreCode",
            TransactionId:"$data.PaymentDetails.TransactionId",
            PaymentStatus:"$data.PaymentDetails.PaymentStatus",
            PaymentAmount:"$data.PaymentDetails.PaymentAmount",
            ItemNos: { $cond: { if: { $isArray: "$data.Products" }, then: { $size: "$data.Products" }, else: "NA"} }
        }
    }
])

Here I am getting Some records as per store code and mobile no. Here I need to push all records into one array using that same query.

Denis Kohl · Accepted Answer · 2020-06-06 06:43:40Z

1

MongoDB has the function toArray() you can do this

db.getCollection().toArray();

https://docs.mongodb.com/manual/reference/method/cursor.toArray/

answered Jun 6, 2020 at 6:43

Denis Kohl

7588 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

How to push all set of record into one array using MongoDB query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related