mongodb aggregation and sorting on nested array

Question

Below is my mongo db document structure

{
"product_json": {
"productId": 1,
"productData": [
  {
    "productName": "A",
    "productDetails": [
      {
        "manufacturedDate": "2014-08-09",
        "name": "A1",
        "size": 300
      },
      {
        "manufacturedDate": "2012-08-09",
        "name": "A2",
        "size": 200
      }
    ]
  },
  {
    "productName": "B",
    "productDetails": [
      {
        "manufacturedDate": "2015-08-09",
        "name": "B1",
        "size": 300
      },
      {
        "manufacturedDate": "2017-08-09",
        "name": "B2",
        "size": 200
       }
     ]
   }
 ]
}
}

I need to group by on "manufacturedDate" and apply sorting.Also i dont want the whole document as match.only the matched object(matched productDetails object).

Try this db.collection.aggregate([ { $unwind: "$product_json.productData" }, { $unwind: "$product_json.productData.productDetails" }, { $group: { _id: "$product_json.productData.productDetails.manufacturedDate", data: { $push: "$product_json.productData.productDetails" } } } ]) — Ashh
– Ashh, Commented Sep 5, 2018 at 11:22
@AnthonyWinzlet i have tried it..i need only the matched inner document not the entire document.. Matched document should be like below document data :[{ "manufacturedDate": "2014-08-09", "name": "A1", "size": 300 }] — sachin
– sachin, Commented Sep 6, 2018 at 6:36

Saurabh Mistry · Accepted Answer · 2018-09-05 10:03:34Z

2

try this query :

db.collection.aggregate(
   [
    {$sort:  {'product_json.productData.productDetails.manufacturedDate': 1}}, 
    { $group:{
      "_id": "$product_json.productData.productDetails.manufacturedDate"
            }
    }
   ]
);

edited Sep 5, 2018 at 10:03

answered Sep 5, 2018 at 9:56

Saurabh Mistry

13.8k5 gold badges60 silver badges78 bronze badges

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

7 Comments

sachin Over a year ago

"productData" is inside the "product_json"

sachin Over a year ago

query is working but i need only the matched object not entire document

Saurabh Mistry Over a year ago

@sachin , please tell me , by which field do you want to match

sachin Over a year ago

"productName" and "size"

Saurabh Mistry Over a year ago

@sachin , are you using node js ?

|

Collectives™ on Stack Overflow

mongodb aggregation and sorting on nested array

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related