db={users:[{"_id":"P4SpYVd1KjBaF4SKyVw0E","login":"User-01","name":"John","lastName":"Doe",},{"_id":"we_9OrnWvSFE2TRrxKbo-","login":"User-02","name":"Helen","lastName":"Smith",},],moods:[{"source":{"userId":"P4SpYVd1KjBaF4SKyVw0E",},"timestamp":"2022-06-11T12:44:13.333Z","mood":"bad","_id":"62a352b83859aaf975c6332d",},{"source":{"userId":"we_9OrnWvSFE2TRrxKbo-",},"timestamp":"2022-06-11T17:24:17.333Z","mood":"good","_id":"62a351ed3859aaf975c63325",},{"source":{"userId":"P4SpYVd1KjBaF4SKyVw0E",},"timestamp":"2022-06-12T08:24:43.333Z","mood":"bad","_id":"43x543v98756bhx098b1432c",},{"source":{"userId":"we_9OrnWvSFE2TRrxKbo-",},"timestamp":"2022-06-12T11:34:27.333Z","mood":"good","_id":"76x123tr9857wwq967r43567",},],contactRequests:[{"timestamp":"2022-06-11T13:24:43.333Z","source":{"userId":"P4SpYVd1KjBaF4SKyVw0E"},"resolve":true,"_id":"43d342sff3859aaf975c63329"},{"timestamp":"2022-06-11T16:14:23.333Z","source":{"userId":"P4SpYVd1KjBaF4SKyVw0E"},"resolve":false,"_id":"23d666sff3859aaf975c34259"},{"timestamp":"2022-06-12T15:15:13.333Z","source":{"userId":"we_9OrnWvSFE2TRrxKbo-"},"resolve":false,"_id":"53d666szz2358aaf975c34439"},]}

db.users.aggregate([{$match:{_id:"P4SpYVd1KjBaF4SKyVw0E"/** id comes from param*/},},{$lookup:{from:"moods",let:{userid:"$_id"},pipeline:[{$match:{$expr:{$eq:["$source.userId","$$userid"]}}},{$lookup:{from:"contactRequests",let:{uid:"$source.userId",moodsDate:{$dateToString:{format:"%Y-%m-%d",date:"$moods.timestamp",},},contactRequestDate:{$dateToString:{format:"%Y-%m-%d",date:"$contactrequests.timestamp",},},},pipeline:[{$match:{$expr:{$and:[{$eq:["$source.userId","$$uid"]},{$eq:["$contactRequestDate","$$moodsDate"]},],},},},],as:"contactRequests"}}],as:"calendar",}},])