[{"_id":"654f4d7cbb027c35a0b90529","msg":"test message","createdat":ISODate("2023-11-11T09:46:41.872Z"),"dateseen":ISODate("2023-11-11T09:55:56.596Z"),"fromid":"eb78a1f79938f5eb193b63fc13b3250","toid":"7b987d98718041abb3b9a85b5c96214a","deleted1":false,"deleted1at":null,"deleted2":false,"deleted2at":null,"type":1}]

db.collection.aggregate([{"$match":{"$or":[{"fromid":"eb78a1f79938f5eb193b63fc13b3250","deleted1":false},{"toid":"eb78a1f79938f5eb193b63fc13b3250","deleted2":false}]}},{$setWindowFields:{partitionBy:"$fromid",sortBy:{createdat:-1},output:{messageRankFrom:{$denseRank:{}}}}},{$setWindowFields:{partitionBy:"$toid",sortBy:{createdat:-1},output:{messageRankTo:{$denseRank:{}}}}},{$match:{$or:[{messageRankFrom:1},{"messageRankTo":1}]}}])