Database
[{"_id":ObjectId("10968e7c34dc25546dbd87fb"),"title":"Task1","user":ObjectId("1077f7207610f32a8d5e7e0c")},{"_id":ObjectId("1096988f8d23679184d619a3"),"title":"Task2","user":ObjectId("1077f7207610f32a8d5e7e0c"),"completed":ISODate("2021-06-03T14:12:04.197Z"),"next_time":ISODate("2021-06-03T14:12:04.197Z")},{"_id":ObjectId("10ac00d944af5d1ebae877b6"),"title":"Task3","creator":ObjectId("1077f7207610f32a8d5e7e0c"),"is_project":true}]
Query
db.collection.aggregate([{$match:{"creator":ObjectId("1077f7207610f32a8d5e7e0c")}},{$sort:{next_time:-1,completed:-1,is_project:-1}}])