[{"_id":ObjectId("6096988f8d23679184d619a3"),"title":"T5","creator":ObjectId("6077f7207610f32a8d5e7e0c"),"completed":ISODate("2021-06-05T08:30:16.197Z"),"next_time":ISODate("2021-06-06T08:30:16.197Z"),"project":ObjectId("60aba9b03a686ce60be89538")},{"_id":ObjectId("60abd6a487bdf6655a393388"),"title":"T6","creator":ObjectId("6077f7207610f32a8d5e7e0c"),"is_project":true,"project":ObjectId("60aba9b03a686ce60be89538")},{"_id":ObjectId("60be85006a5355235313575e"),"title":"T1","creator":ObjectId("6077f7207610f32a8d5e7e0c"),"project":ObjectId("60aba9b03a686ce60be89538"),"next_time":ISODate("2021-06-08T23:44:26.197Z")},{"_id":ObjectId("60be85016a5355235313575f"),"title":"T2","creator":ObjectId("6077f7207610f32a8d5e7e0c"),"project":ObjectId("60aba9b03a686ce60be89538")},{"_id":ObjectId("60be85056a53552353135761"),"title":"T4","creator":ObjectId("6077f7207610f32a8d5e7e0c"),"project":ObjectId("60aba9b03a686ce60be89538"),"completed":ISODate("2021-06-07T20:44:10.197Z"),"next_time":null},{"_id":ObjectId("60be85036a53552353135760"),"title":"T3","creator":ObjectId("6077f7207610f32a8d5e7e0c"),"project":ObjectId("60aba9b03a686ce60be89538"),"completed":ISODate("2021-06-07T20:44:03.197Z"),"next_time":null}]

db.collection.aggregate([{"$facet":{"reactivated":[{$match:{"next_time":{$lt:ISODate("2021-06-08T08:30:16.197Z")},"project":ObjectId("60aba9b03a686ce60be89538")}},{$sort:{"is_project":-1}}],"uncompleted":[{$match:{"project":ObjectId("60aba9b03a686ce60be89538"),"completed":"None"}},{$sort:{"is_project":-1}}],"completed_new_old":[{$match:{"project":ObjectId("60aba9b03a686ce60be89538"),"completed":{"$ne":"None"},"$or":[{"next_time":{"$gt":ISODate("2021-06-08T08:30:16.197Z")}},{"next_time":"None"}]}},{$sort:{"is_project":-1,"completed":-1}}]}}])