how to sort array inside collection in mongoDB using node js

Question

I have a collection of queries,data stored on the records look like the following.i want to sort according to the id or the date inside the array in descending orders

[
    {
        "_id": "5e71fa3ab004192b349e4a06",
        "QUERIES": [
            {
                "_id": "5e71fa3ab004192b349e4a07",
                "QUERY": "1",
                "USER_ID": "5e6f1c5b8451307f782d0994",
                "USER_NAME": "a2",
                "createdAt": "2020-03-18T10:38:50.247Z"
            },
            {
                "_id": "5e71fa46b004192b349e4a08",
                "QUERY": "2",
                "USER_ID": "5e6f1c5b8451307f782d0994",
                "USER_NAME": "a1",
                "createdAt": "2020-03-18T10:39:02.451Z"
            }
        ],
        "TICKET_ID": "5e70f4fa47df9479502f7937"
]

Expected output

[
        {
            "_id": "5e71fa3ab004192b349e4a06",
            "QUERIES": [

                {
                    "_id": "5e71fa46b004192b349e4a08",
                    "QUERY": "2",
                    "USER_ID": "5e6f1c5b8451307f782d0994",
                    "USER_NAME": "a1",
                    "createdAt": "2020-03-18T10:39:02.451Z"
                },
                {
                    "_id": "5e71fa3ab004192b349e4a07",
                    "QUERY": "1",
                    "USER_ID": "5e6f1c5b8451307f782d0994",
                    "USER_NAME": "a2",
                    "createdAt": "2020-03-18T10:38:50.247Z"
                }
            ],
            "TICKET_ID": "5e70f4fa47df9479502f7937"
    ]

See here: stackoverflow.com/questions/54366459/…. is that what you want? — Jorge Guerra Pires
– Jorge Guerra Pires, Commented Mar 18, 2020 at 11:27
I want mongoDB query code for getting the expected output,which is already mentioned on the question — Sufail Kalathil
– Sufail Kalathil, Commented Mar 18, 2020 at 12:13

Wernfried Domscheit · Accepted Answer · 2020-03-18 12:20:15Z

0

Use this one:

db.collection.aggregate([
   { $unwind: "$QUERIES" },
   { $sort: { "QUERIES.createdAt": -1 } },
   {
      $group: {
         _id: { _id: "$_id", TICKET_ID: "$TICKET_ID" },
         QUERIES: { $push: "$QUERIES" }
      }
   },
   { $replaceRoot: { newRoot: { $mergeObjects: ["$$ROOT", "$_id"] } } }
])

Mongo playground

answered Mar 18, 2020 at 12:20

Wernfried Domscheit

60.4k10 gold badges92 silver badges132 bronze badges

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

1 Comment

Sufail Kalathil Over a year ago

Thank you @Wernfried Domscheit

Collectives™ on Stack Overflow

how to sort array inside collection in mongoDB using node js

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related