Database
[{_id:1,title:"Artikel 1",publishedAt:ISODate("2024-08-30")},{_id:2,title:"Artikel 2",publishedAt:ISODate("2024-08-29")},{_id:3,title:"Artikel 3",publishedAt:ISODate("2024-08-28")},{_id:4,title:"Artikel 4",publishedAt:ISODate("2024-08-27")},{_id:5,title:"Artikel 5",publishedAt:ISODate("2024-08-26")}]
Query
db.collection.aggregate([{"$setWindowFields":{"partitionBy":null,"sortBy":{"publishedAt":1},"output":{nearDocs:{$addToSet:"$$ROOT",window:{documents:[-1,1]}}}}},{"$match":{_id:2}},{"$unwind":"$nearDocs"},{"$replaceRoot":{"newRoot":"$nearDocs"}}])