db={"parks":[{"_id":"400400400","name":"One Stop","spaces":"50","createdAt":ISODate("2022-05-11T14:25:44.816Z"),"contacts":{"mainPhoneNumber":"800000000","optionalPhoneNumber":"800000000","province":"1","district":"matola a","avenue":"filipe","quarterNumber":"12","residenceNumber":"1","floorNumber":"1"},"packages":[{"_id":ObjectId("627bfc95834d42107eeefc93"),"name":"Basic One","isPeriodic":0,"createdAt":ISODate("2022-05-11T18:12:37.024Z"),"articles":[{"_id":ObjectId("627e462842a6d1357a37613d"),"period":"00:00:00:01:00","price":NumberDecimal("100")},{"_id":ObjectId("627e4ede3c0615d81a3783b3"),"period":"00:01:00:00:00","price":NumberDecimal("1700")},{"_id":ObjectId("627e4f4f3c0615d81a3783b4"),"period":"00:00:00:01:30","price":NumberDecimal("200.99")},{"_id":ObjectId("627e4f692ffd3313694bf88d"),"period":"00:00:01:20:00","price":NumberDecimal("300.5")}]},{"_id":ObjectId("627bfee7c528a41f5fd74664"),"name":"Anual básico","isPeriodic":0,"createdAt":ISODate("2022-05-11T18:22:31.624Z")},{"_id":ObjectId("627c16b5b91ad0563d22f8eb"),"name":"básico","isPeriodic":0,"createdAt":ISODate("2022-05-11T20:04:05.462Z")},{"_id":ObjectId("627c16e028c58a28175e7327"),"name":"Anual","isPeriodic":0,"createdAt":ISODate("2022-05-11T20:04:48.863Z")}]},{"_id":"400400300","name":"Just Us","spaces":"20","createdAt":ISODate("2022-05-11T14:27:08.529Z"),"contacts":{"mainPhoneNumber":"800000000","optionalPhoneNumber":"800000000","province":"1","district":"matola a","avenue":"filipe","quarterNumber":"12","residenceNumber":"1","floorNumber":"1"},"packages":[{"_id":ObjectId("627c2e1162cdb5d5da2b020e"),"name":"Plus","isPeriodic":1,"createdAt":ISODate("2022-05-11T21:43:45.321Z")}]},{"_id":"400200400","name":"Securex","spaces":"13","createdAt":ISODate("2022-05-11T15:16:35.080Z"),"contacts":{"mainPhoneNumber":"800000000","optionalPhoneNumber":"800000000","province":"1","district":"matola a","avenue":"filipe","quarterNumber":"10","residenceNumber":"1","floorNumber":"1"}},{"_id":"400100400","name":"Mundial Setembro","spaces":"100","createdAt":ISODate("2022-05-13T13:09:53.473Z"),"contacts":{"mainPhoneNumber":"841234152","optionalPhoneNumber":"849001122","province":"1","district":"Maxaquene C","avenue":"Filipe Samuel Magaia","quarterNumber":"29b","residenceNumber":"1","floorNumber":"1"},"packages":[{"_id":ObjectId("627e58c72a6c67eece6e0741"),"name":"Mensal Max","isPeriodic":1,"createdAt":ISODate("2022-05-13T13:10:31.380Z"),"articles":[{"_id":ObjectId("627e58eb2a6c67eece6e0742"),"period":"00:00:01:00:00","price":NumberDecimal("100.50")}]}]},{"_id":"400600600","name":"Lexeme","spaces":"40","createdAt":ISODate("2022-05-16T14:10:56.440Z"),"contacts":{"mainPhoneNumber":"800000000","optionalPhoneNumber":"800000000","province":"1","district":"Maxaquene C","avenue":"5 de fevereiro","quarterNumber":"5b","residenceNumber":"1","floorNumber":"1"}}],"reservations":[{"_id":ObjectId("6284c0220d5752c8b692ef2f"),"nuit":"400400400","packageId":ObjectId("627bfc95834d42107eeefc93"),"regNumber":"aha-720-mp","date":{"entry":ISODate("2022-05-18T09:45:00Z"),"exit":ISODate("2022-05-19T09:45:00Z")}},{"_id":ObjectId("6284c8915a5e7a6a6ec675c1"),"nuit":"400400400","packageId":ObjectId("627bfee7c528a41f5fd74664"),"regNumber":"aha-720-mp","date":{"entry":ISODate("2022-05-25T10:20:00Z"),"exit":ISODate("2022-05-29T10:20:00Z")}}]}

db.reservations.aggregate([{$match:{nuit:"400400400",regNumber:"aha-720-mp"}},{$sort:{_id:-1}},{$limit:1},{$lookup:{from:"parks",let:{nuit:"$nuit",pid:"$packageId"},pipeline:[{$unwind:"$packages"},{$match:{$expr:{$and:[{$eq:["$_id","$$nuit"]},{$eq:["$packages._id","$$pid"]}]}}},{$project:{_id:0,"packages.isPeriodic":1}}],as:"park"}},{$unwind:"$park"}])