Database

db={"Products":[{"_fid":"60508eeb52a2ab598a013222","message":"hello","field1":false,"field2":1,"field3":"something","date":"2022-05-26T13:42:24.293+0000"},{"_fid":"60508f4152a2ab598a013111","message":"hello","field1":false,"field2":1,"field3":"s1","date":"2022-05-26T13:42:24.293+0000"},{"_fid":"60508f2852a2ab665a013333","message":"hello","field1":false,"field2":1,"field3":"s1","date":"2022-05-26T13:42:24.293+0000"}],"Products_History":[{"_fid":"60508eeb52a2ab598a013222","version":"1","date":"2022-05-26T13:42:24.293+0000"},{"_fid":"60508eeb52a2ab598a013222","version":"2","date":"2021-01-26T13:42:24.293+0000"},{"_fid":"60508eeb52a2ab598a013222","version":"3","date":"2022-02-26T13:42:24.293+0000"}]}

Query

db.Products.aggregate([{$lookup:{from:"Products_History",localField:"_fid",foreignField:"_fid",as:"joins",pipeline:[{"$sort":{"date":-1}}]}},{"$project":{"_fid":1,"field1":1,"field2":1,"field3":1,"last_version":{$first:"$joins.version"}}},{$match:{"last_version":{$exists:true}}}])

Result