db={"mainCollection":[{"_id":"mainId0","refId1":"507f1f77bcf86cd799439010","refId2":"507f1f77bcf86cd799439008","refId3":"507f1f77bcf86cd799439013","fieldA":"fieldAVal0","fieldB":"fieldBVal0","createdAt":"2025-06-08 07:02:00.416487+00:00"},{"_id":"mainId1","refId1":"507f1f77bcf86cd799439010","refId2":"507f1f77bcf86cd799439013","refId3":"507f1f77bcf86cd799439005","fieldA":"fieldAVal1","fieldB":"fieldBVal1","createdAt":"2025-06-07 07:02:00.416494+00:00"},{"_id":"mainId2","refId1":"507f1f77bcf86cd799439008","refId2":"507f1f77bcf86cd799439007","refId3":"507f1f77bcf86cd799439009","fieldA":"fieldAVal2","fieldB":"fieldBVal2","createdAt":"2025-06-06 07:02:00.416500+00:00"},{"_id":"mainId3","refId1":"507f1f77bcf86cd799439006","refId2":"507f1f77bcf86cd799439000","refId3":"507f1f77bcf86cd799439011","fieldA":"fieldAVal3","fieldB":"fieldBVal3","createdAt":"2025-06-05 07:02:00.416504+00:00"},{"_id":"mainId4","refId1":"507f1f77bcf86cd799439018","refId2":"507f1f77bcf86cd799439001","refId3":"507f1f77bcf86cd799439019","fieldA":"fieldAVal4","fieldB":"fieldBVal4","createdAt":"2025-06-04 07:02:00.416508+00:00"},{"_id":"mainId5","refId1":"507f1f77bcf86cd799439002","refId2":"507f1f77bcf86cd799439009","refId3":"507f1f77bcf86cd799439008","fieldA":"fieldAVal5","fieldB":"fieldBVal5","createdAt":"2025-06-03 07:02:00.416512+00:00"},{"_id":"mainId6","refId1":"507f1f77bcf86cd799439018","refId2":"507f1f77bcf86cd799439004","refId3":"507f1f77bcf86cd799439012","fieldA":"fieldAVal6","fieldB":"fieldBVal6","createdAt":"2025-06-02 07:02:00.416516+00:00"},{"_id":"mainId7","refId1":"507f1f77bcf86cd799439007","refId2":"507f1f77bcf86cd799439015","refId3":"507f1f77bcf86cd799439010","fieldA":"fieldAVal7","fieldB":"fieldBVal7","createdAt":"2025-06-01 07:02:00.416520+00:00"},{"_id":"mainId8","refId1":"507f1f77bcf86cd799439007","refId2":"507f1f77bcf86cd799439015","refId3":"507f1f77bcf86cd799439014","fieldA":"fieldAVal8","fieldB":"fieldBVal8","createdAt":"2025-05-31 07:02:00.416524+00:00"},{"_id":"mainId9","refId1":"507f1f77bcf86cd799439001","refId2":"507f1f77bcf86cd799439014","refId3":"507f1f77bcf86cd799439012","fieldA":"fieldAVal9","fieldB":"fieldBVal9","createdAt":"2025-05-30 07:02:00.416528+00:00"},{"_id":"mainId10","refId1":"507f1f77bcf86cd799439017","refId2":"507f1f77bcf86cd799439005","refId3":"507f1f77bcf86cd799439016","fieldA":"fieldAVal10","fieldB":"fieldBVal10","createdAt":"2025-05-29 07:02:00.416532+00:00"},{"_id":"mainId11","refId1":"507f1f77bcf86cd799439004","refId2":"507f1f77bcf86cd799439010","refId3":"507f1f77bcf86cd799439007","fieldA":"fieldAVal11","fieldB":"fieldBVal11","createdAt":"2025-05-28 07:02:00.416536+00:00"},{"_id":"mainId12","refId1":"507f1f77bcf86cd799439017","refId2":"507f1f77bcf86cd799439005","refId3":"507f1f77bcf86cd799439015","fieldA":"fieldAVal12","fieldB":"fieldBVal12","createdAt":"2025-05-27 07:02:00.416541+00:00"},{"_id":"mainId13","refId1":"507f1f77bcf86cd799439006","refId2":"507f1f77bcf86cd799439012","refId3":"507f1f77bcf86cd799439002","fieldA":"fieldAVal13","fieldB":"fieldBVal13","createdAt":"2025-05-26 07:02:00.416545+00:00"},{"_id":"mainId14","refId1":"507f1f77bcf86cd799439003","refId2":"507f1f77bcf86cd799439014","refId3":"507f1f77bcf86cd799439013","fieldA":"fieldAVal14","fieldB":"fieldBVal14","createdAt":"2025-05-25 07:02:00.416549+00:00"},{"_id":"mainId15","refId1":"507f1f77bcf86cd799439017","refId2":"507f1f77bcf86cd799439011","refId3":"507f1f77bcf86cd799439002","fieldA":"fieldAVal15","fieldB":"fieldBVal15","createdAt":"2025-05-24 07:02:00.416553+00:00"},{"_id":"mainId16","refId1":"507f1f77bcf86cd799439003","refId2":"507f1f77bcf86cd799439008","refId3":"507f1f77bcf86cd799439002","fieldA":"fieldAVal16","fieldB":"fieldBVal16","createdAt":"2025-05-23 07:02:00.416556+00:00"},{"_id":"mainId17","refId1":"507f1f77bcf86cd799439013","refId2":"507f1f77bcf86cd799439001","refId3":"507f1f77bcf86cd799439018","fieldA":"fieldAVal17","fieldB":"fieldBVal17","createdAt":"2025-05-22 07:02:00.416560+00:00"},{"_id":"mainId18","refId1":"507f1f77bcf86cd799439010","refId2":"507f1f77bcf86cd799439009","refId3":"507f1f77bcf86cd799439004","fieldA":"fieldAVal18","fieldB":"fieldBVal18","createdAt":"2025-05-21 07:02:00.416564+00:00"},{"_id":"mainId19","refId1":"507f1f77bcf86cd799439008","refId2":"507f1f77bcf86cd799439017","refId3":"507f1f77bcf86cd799439015","fieldA":"fieldAVal19","fieldB":"fieldBVal19","createdAt":"2025-05-20 07:02:00.416568+00:00"}],"relatedCollection":[{"_id":"507f1f77bcf86cd799439000","fieldC":"FieldCValue0","fieldD":"Contact0@example.com","contact":{"email":"user0@example.com","phone":"+91-999990000"},"status":"pending","metadata":{"createdBy":"admin0","updatedBy":"user0"},"address":{"street":"0 Example Street","city":"City0","zip":"40000"},"role":"admin","organization":"Org0","linkedin":"https://linkedin.com/in/user0","twitter":"https://twitter.com/user0","github":"https://github.com/user0","notes":"Test notes for user 0","joinedAt":"2024-10-23 07:02:00.414204+00:00","skills":["Skill0","Skill1","Skill2"],"tags":["tag0","tag1"],"experience":"10 years","isVerified":true,"priority":"low","customField":"CustomValue0"},{"_id":"507f1f77bcf86cd799439001","fieldC":"FieldCValue1","fieldD":"Contact1@example.com","contact":{"email":"user1@example.com","phone":"+91-999990001"},"status":"active","metadata":{"createdBy":"admin1","updatedBy":"user1"},"address":{"street":"1 Example Street","city":"City1","zip":"40001"},"role":"staff","organization":"Org1","linkedin":"https://linkedin.com/in/user1","twitter":"https://twitter.com/user1","github":"https://github.com/user1","notes":"Test notes for user 1","joinedAt":"2024-07-03 07:02:00.416327+00:00","skills":["Skill0","Skill1","Skill2"],"tags":["tag1","tag2"],"experience":"1 years","isVerified":true,"priority":"medium","customField":"CustomValue1"},{"_id":"507f1f77bcf86cd799439002","fieldC":"FieldCValue2","fieldD":"Contact2@example.com","contact":{"email":"user2@example.com","phone":"+91-999990002"},"status":"inactive","metadata":{"createdBy":"admin2","updatedBy":"user2"},"address":{"street":"2 Example Street","city":"City2","zip":"40002"},"role":"admin","organization":"Org2","linkedin":"https://linkedin.com/in/user2","twitter":"https://twitter.com/user2","github":"https://github.com/user2","notes":"Test notes for user 2","joinedAt":"2024-10-16 07:02:00.416338+00:00","skills":["Skill0","Skill1","Skill2"],"tags":["tag2","tag3"],"experience":"2 years","isVerified":true,"priority":"high","customField":"CustomValue2"},{"_id":"507f1f77bcf86cd799439003","fieldC":"FieldCValue3","fieldD":"Contact3@example.com","contact":{"email":"user3@example.com","phone":"+91-999990003"},"status":"active","metadata":{"createdBy":"admin3","updatedBy":"user3"},"address":{"street":"3 Example Street","city":"City3","zip":"40003"},"role":"admin","organization":"Org3","linkedin":"https://linkedin.com/in/user3","twitter":"https://twitter.com/user3","github":"https://github.com/user3","notes":"Test notes for user 3","joinedAt":"2024-08-19 07:02:00.416347+00:00","skills":["Skill0","Skill1","Skill2"],"tags":["tag3","tag4"],"experience":"5 years","isVerified":false,"priority":"medium","customField":"CustomValue3"},{"_id":"507f1f77bcf86cd799439004","fieldC":"FieldCValue4","fieldD":"Contact4@example.com","contact":{"email":"user4@example.com","phone":"+91-999990004"},"status":"inactive","metadata":{"createdBy":"admin4","updatedBy":"user4"},"address":{"street":"4 Example Street","city":"City4","zip":"40004"},"role":"staff","organization":"Org4","linkedin":"https://linkedin.com/in/user4","twitter":"https://twitter.com/user4","github":"https://github.com/user4","notes":"Test notes for user 4","joinedAt":"2022-10-04 07:02:00.416354+00:00","skills":["Skill0","Skill1","Skill2"],"tags":["tag4","tag5"],"experience":"9 years","isVerified":true,"priority":"high","customField":"CustomValue4"},{"_id":"507f1f77bcf86cd799439005","fieldC":"FieldCValue5","fieldD":"Contact5@example.com","contact":{"email":"user5@example.com","phone":"+91-999990005"},"status":"active","metadata":{"createdBy":"admin5","updatedBy":"user5"},"address":{"street":"5 Example Street","city":"City5","zip":"40005"},"role":"staff","organization":"Org5","linkedin":"https://linkedin.com/in/user5","twitter":"https://twitter.com/user5","github":"https://github.com/user5","notes":"Test notes for user 5","joinedAt":"2022-10-24 07:02:00.416364+00:00","skills":["Skill0","Skill1","Skill2"],"tags":["tag5","tag6"],"experience":"3 years","isVerified":false,"priority":"medium","customField":"CustomValue5"},{"_id":"507f1f77bcf86cd799439006","fieldC":"FieldCValue6","fieldD":"Contact6@example.com","contact":{"email":"user6@example.com","phone":"+91-999990006"},"status":"pending","metadata":{"createdBy":"admin6","updatedBy":"user6"},"address":{"street":"6 Example Street","city":"City6","zip":"40006"},"role":"staff","organization":"Org6","linkedin":"https://linkedin.com/in/user6","twitter":"https://twitter.com/user6","github":"https://github.com/user6","notes":"Test notes for user 6","joinedAt":"2024-01-14 07:02:00.416370+00:00","skills":["Skill0","Skill1","Skill2"],"tags":["tag6","tag7"],"experience":"6 years","isVerified":false,"priority":"medium","customField":"CustomValue6"},{"_id":"507f1f77bcf86cd799439007","fieldC":"FieldCValue7","fieldD":"Contact7@example.com","contact":{"email":"user7@example.com","phone":"+91-999990007"},"status":"pending","metadata":{"createdBy":"admin7","updatedBy":"user7"},"address":{"street":"7 Example Street","city":"City7","zip":"40007"},"role":"admin","organization":"Org7","linkedin":"https://linkedin.com/in/user7","twitter":"https://twitter.com/user7","github":"https://github.com/user7","notes":"Test notes for user 7","joinedAt":"2024-09-16 07:02:00.416377+00:00","skills":["Skill0","Skill1","Skill2"],"tags":["tag7","tag8"],"experience":"1 years","isVerified":true,"priority":"medium","customField":"CustomValue7"},{"_id":"507f1f77bcf86cd799439008","fieldC":"FieldCValue8","fieldD":"Contact8@example.com","contact":{"email":"user8@example.com","phone":"+91-999990008"},"status":"inactive","metadata":{"createdBy":"admin8","updatedBy":"user8"},"address":{"street":"8 Example Street","city":"City8","zip":"40008"},"role":"staff","organization":"Org8","linkedin":"https://linkedin.com/in/user8","twitter":"https://twitter.com/user8","github":"https://github.com/user8","notes":"Test notes for user 8","joinedAt":"2022-11-17 07:02:00.416384+00:00","skills":["Skill0","Skill1","Skill2"],"tags":["tag8","tag9"],"experience":"10 years","isVerified":true,"priority":"medium","customField":"CustomValue8"},{"_id":"507f1f77bcf86cd799439009","fieldC":"FieldCValue9","fieldD":"Contact9@example.com","contact":{"email":"user9@example.com","phone":"+91-999990009"},"status":"pending","metadata":{"createdBy":"admin9","updatedBy":"user9"},"address":{"street":"9 Example Street","city":"City9","zip":"40009"},"role":"manager","organization":"Org9","linkedin":"https://linkedin.com/in/user9","twitter":"https://twitter.com/user9","github":"https://github.com/user9","notes":"Test notes for user 9","joinedAt":"2023-11-01 07:02:00.416391+00:00","skills":["Skill0","Skill1","Skill2"],"tags":["tag9","tag10"],"experience":"5 years","isVerified":true,"priority":"low","customField":"CustomValue9"},{"_id":"507f1f77bcf86cd799439010","fieldC":"FieldCValue10","fieldD":"Contact10@example.com","contact":{"email":"user10@example.com","phone":"+91-999990010"},"status":"active","metadata":{"createdBy":"admin10","updatedBy":"user10"},"address":{"street":"10 Example Street","city":"City10","zip":"400010"},"role":"admin","organization":"Org10","linkedin":"https://linkedin.com/in/user10","twitter":"https://twitter.com/user10","github":"https://github.com/user10","notes":"Test notes for user 10","joinedAt":"2023-11-16 07:02:00.416399+00:00","skills":["Skill0","Skill1","Skill2"],"tags":["tag10","tag11"],"experience":"5 years","isVerified":false,"priority":"low","customField":"CustomValue10"},{"_id":"507f1f77bcf86cd799439011","fieldC":"FieldCValue11","fieldD":"Contact11@example.com","contact":{"email":"user11@example.com","phone":"+91-999990011"},"status":"inactive","metadata":{"createdBy":"admin11","updatedBy":"user11"},"address":{"street":"11 Example Street","city":"City11","zip":"400011"},"role":"admin","organization":"Org11","linkedin":"https://linkedin.com/in/user11","twitter":"https://twitter.com/user11","github":"https://github.com/user11","notes":"Test notes for user 11","joinedAt":"2024-04-25 07:02:00.416406+00:00","skills":["Skill0","Skill1","Skill2"],"tags":["tag11","tag12"],"experience":"2 years","isVerified":false,"priority":"high","customField":"CustomValue11"},{"_id":"507f1f77bcf86cd799439012","fieldC":"FieldCValue12","fieldD":"Contact12@example.com","contact":{"email":"user12@example.com","phone":"+91-999990012"},"status":"pending","metadata":{"createdBy":"admin12","updatedBy":"user12"},"address":{"street":"12 Example Street","city":"City12","zip":"400012"},"role":"admin","organization":"Org12","linkedin":"https://linkedin.com/in/user12","twitter":"https://twitter.com/user12","github":"https://github.com/user12","notes":"Test notes for user 12","joinedAt":"2023-12-23 07:02:00.416416+00:00","skills":["Skill0","Skill1","Skill2"],"tags":["tag12","tag13"],"experience":"4 years","isVerified":true,"priority":"high","customField":"CustomValue12"},{"_id":"507f1f77bcf86cd799439013","fieldC":"FieldCValue13","fieldD":"Contact13@example.com","contact":{"email":"user13@example.com","phone":"+91-999990013"},"status":"inactive","metadata":{"createdBy":"admin13","updatedBy":"user13"},"address":{"street":"13 Example Street","city":"City13","zip":"400013"},"role":"manager","organization":"Org13","linkedin":"https://linkedin.com/in/user13","twitter":"https://twitter.com/user13","github":"https://github.com/user13","notes":"Test notes for user 13","joinedAt":"2023-09-25 07:02:00.416424+00:00","skills":["Skill0","Skill1","Skill2"],"tags":["tag13","tag14"],"experience":"3 years","isVerified":true,"priority":"high","customField":"CustomValue13"},{"_id":"507f1f77bcf86cd799439014","fieldC":"FieldCValue14","fieldD":"Contact14@example.com","contact":{"email":"user14@example.com","phone":"+91-999990014"},"status":"pending","metadata":{"createdBy":"admin14","updatedBy":"user14"},"address":{"street":"14 Example Street","city":"City14","zip":"400014"},"role":"admin","organization":"Org14","linkedin":"https://linkedin.com/in/user14","twitter":"https://twitter.com/user14","github":"https://github.com/user14","notes":"Test notes for user 14","joinedAt":"2023-07-10 07:02:00.416431+00:00","skills":["Skill0","Skill1","Skill2"],"tags":["tag14","tag15"],"experience":"9 years","isVerified":true,"priority":"medium","customField":"CustomValue14"},{"_id":"507f1f77bcf86cd799439015","fieldC":"FieldCValue15","fieldD":"Contact15@example.com","contact":{"email":"user15@example.com","phone":"+91-999990015"},"status":"active","metadata":{"createdBy":"admin15","updatedBy":"user15"},"address":{"street":"15 Example Street","city":"City15","zip":"400015"},"role":"staff","organization":"Org15","linkedin":"https://linkedin.com/in/user15","twitter":"https://twitter.com/user15","github":"https://github.com/user15","notes":"Test notes for user 15","joinedAt":"2023-01-13 07:02:00.416438+00:00","skills":["Skill0","Skill1","Skill2"],"tags":["tag15","tag16"],"experience":"7 years","isVerified":false,"priority":"medium","customField":"CustomValue15"},{"_id":"507f1f77bcf86cd799439016","fieldC":"FieldCValue16","fieldD":"Contact16@example.com","contact":{"email":"user16@example.com","phone":"+91-999990016"},"status":"inactive","metadata":{"createdBy":"admin16","updatedBy":"user16"},"address":{"street":"16 Example Street","city":"City16","zip":"400016"},"role":"admin","organization":"Org16","linkedin":"https://linkedin.com/in/user16","twitter":"https://twitter.com/user16","github":"https://github.com/user16","notes":"Test notes for user 16","joinedAt":"2023-02-23 07:02:00.416445+00:00","skills":["Skill0","Skill1","Skill2"],"tags":["tag16","tag17"],"experience":"1 years","isVerified":true,"priority":"high","customField":"CustomValue16"},{"_id":"507f1f77bcf86cd799439017","fieldC":"FieldCValue17","fieldD":"Contact17@example.com","contact":{"email":"user17@example.com","phone":"+91-999990017"},"status":"pending","metadata":{"createdBy":"admin17","updatedBy":"user17"},"address":{"street":"17 Example Street","city":"City17","zip":"400017"},"role":"staff","organization":"Org17","linkedin":"https://linkedin.com/in/user17","twitter":"https://twitter.com/user17","github":"https://github.com/user17","notes":"Test notes for user 17","joinedAt":"2022-11-07 07:02:00.416452+00:00","skills":["Skill0","Skill1","Skill2"],"tags":["tag17","tag18"],"experience":"1 years","isVerified":false,"priority":"low","customField":"CustomValue17"},{"_id":"507f1f77bcf86cd799439018","fieldC":"FieldCValue18","fieldD":"Contact18@example.com","contact":{"email":"user18@example.com","phone":"+91-999990018"},"status":"pending","metadata":{"createdBy":"admin18","updatedBy":"user18"},"address":{"street":"18 Example Street","city":"City18","zip":"400018"},"role":"admin","organization":"Org18","linkedin":"https://linkedin.com/in/user18","twitter":"https://twitter.com/user18","github":"https://github.com/user18","notes":"Test notes for user 18","joinedAt":"2023-01-12 07:02:00.416459+00:00","skills":["Skill0","Skill1","Skill2"],"tags":["tag18","tag19"],"experience":"1 years","isVerified":false,"priority":"medium","customField":"CustomValue18"},{"_id":"507f1f77bcf86cd799439019","fieldC":"FieldCValue19","fieldD":"Contact19@example.com","contact":{"email":"user19@example.com","phone":"+91-999990019"},"status":"inactive","metadata":{"createdBy":"admin19","updatedBy":"user19"},"address":{"street":"19 Example Street","city":"City19","zip":"400019"},"role":"staff","organization":"Org19","linkedin":"https://linkedin.com/in/user19","twitter":"https://twitter.com/user19","github":"https://github.com/user19","notes":"Test notes for user 19","joinedAt":"2024-09-09 07:02:00.416466+00:00","skills":["Skill0","Skill1","Skill2"],"tags":["tag19","tag20"],"experience":"5 years","isVerified":false,"priority":"medium","customField":"CustomValue19"}]}

db.mainCollection.aggregate([{$sort:{createdAt:-1}},{$addFields:{relatedIds:["$refId1","$refId2","$refId3"]}},{$lookup:{from:"relatedCollection",localField:"relatedIds",foreignField:"_id",as:"relatedDetails"}},{$match:{$or:[{fieldA:"FieldCValue12"},{fieldB:"FieldCValue12"},{"relatedDetails.fieldC":"FieldCValue12"},{"relatedDetails.fieldD":{$regex:"FieldCValue12",$options:"i"}}]}},{$skip:0},{$limit:10},{$addFields:{refId1Details:{$first:{$filter:{input:"$relatedDetails",as:"rel",cond:{$eq:["$$rel._id","$refId1"]}}}},refId2Details:{$first:{$filter:{input:"$relatedDetails",as:"rel",cond:{$eq:["$$rel._id","$refId2"]}}}},refId3Details:{$first:{$filter:{input:"$relatedDetails",as:"rel",cond:{$eq:["$$rel._id","$refId3"]}}}}}},{$addFields:{id:"$_id"}}])