Database
[{"userId":0,"docId":0,"createdDate":ISODate("2024-03-20T09:22:24Z")},{"userId":0,"docId":2,"createdDate":ISODate("2024-03-20T09:22:24Z")},{"userId":1,"docId":1,"createdDate":ISODate("2024-01-15T09:22:24Z")},{"userId":1,"docId":4,"createdDate":ISODate("2024-01-15T09:22:24Z")},{"userId":2,"docId":5,"createdDate":ISODate("2024-01-15T09:22:24Z")},{"userId":1,"docId":6,"createdDate":ISODate("2024-01-15T09:22:24Z")}]
Query
db.collection.aggregate([{"$setWindowFields":{"partitionBy":"$userId","sortBy":{"docId":1},"output":{"grouping":{"$first":"$userId"},"orderWithinGroup":{"$rank":{}}}}},{"$sort":{"orderWithinGroup":1,"grouping":1}},{"$set":{"grouping":"$$REMOVE","orderWithinGroup":"$$REMOVE"}}])