db={"journalists":[{_id:ObjectId("6125f93f5fb88535beecd8ee"),journalist_FirstName:"Shyam",journalist_LastName:"Kapoor",},{_id:ObjectId("6125f26b5fb88535beecd8c7"),journalist_FirstName:"Kabita",journalist_LastName:"Mohan",}],"Stories":[{_id:ObjectId("5ec3ca7fa248314329a5a287"),journalistId:ObjectId("6125f26b5fb88535beecd8c7"),/**local id to journalists collection*/storyTitle:"Joining of two tables",briefDescription:"MongoDB joining of tables",keywordName:["temple City,Bhubaneswar,Odisha,Architecture,Temples,heritage"]},{_id:ObjectId("5ec3ca7fa248314329a5a288"),journalistId:ObjectId("6125f26b5fb88535beecd8c7"),/**local id to journalists collection*/storyTitle:"Joining of two ",briefDescription:"MongoDB joining of tables",keywordName:["temple City,Bhubaneswar,Odisha,Architecture,Temples"]}]}

db.journalists.aggregate([{"$lookup":{"from":"Stories","localField":"_id","foreignField":"journalistId","as":"stories_docs"}},{"$unwind":"$stories_docs"},{$match:{$or:[{"journalist_FirstName":{"$regex":"tables","$options":"i"}},{"stories_docs.briefDescription":{"$regex":"tables","$options":"i"}},{"stories_docs.storyTitle":{"$regex":"tables","$options":"i"}},]}},{"$match":{"stories_docs.keywordName":{"$regex":"Heritage","$options":"i"}}}])