[{"_id":ObjectId("61c9d42fc87b10aab2e6732a"),"accountid":122,"jobs":[{"jobid":12,"activity":[{"firstname":"Vikas Yadav Bhai","middlename":null,"lastname":"Yadav","email":"candidate1@abc.com","activityname":"inserted the data into candidate engagement workflow","modifiedbyuserid":151,"modifiedtime":ISODate("2015-12-01T05:30:00.000+05:30"),"createdbyuserid":151,"createddatetime":ISODate("2015-08-12T00:00:00.000+05:30")},{"firstname":"Vikas Yadav Bhai","middlename":null,"lastname":"Yadav","email":"candidate2@abc.com","activityname":"updated the job details","modifiedbyuserid":151,"modifiedtime":ISODate("2015-12-01T05:30:00.000+05:30"),"createdbyuserid":151,"createddatetime":ISODate("2015-08-12T00:00:00.000+05:30")}]}]},{"_id":ObjectId("61c9d42fc87b10aab2e6732b"),"accountid":122,"jobs":[{"jobid":13,"activity":[{"firstname":"Vikas Yadav Bhai","middlename":null,"lastname":"Yadav","email":"candidate1@abc.com","activityname":"inserted the data into candidate engagement workflow","modifiedbyuserid":151,"modifiedtime":ISODate("2015-12-01T05:30:00.000+05:30"),"createdbyuserid":151,"createddatetime":ISODate("2015-08-12T00:00:00.000+05:30")},{"firstname":"Vikas Yadav Bhai","middlename":null,"lastname":"Yadav","email":"candidate2@abc.com","activityname":"updated the job details","modifiedbyuserid":151,"modifiedtime":ISODate("2015-12-01T05:30:00.000+05:30"),"createdbyuserid":151,"createddatetime":ISODate("2015-08-12T00:00:00.000+05:30")}]}]},{"_id":ObjectId("61c9d42fc87b10aab2e6732c"),"accountid":122,"jobs":[{"jobid":12,"activity":[{"firstname":"Vikas Yadav Bhai","middlename":null,"lastname":"Yadav","email":"candidate2@abc.com","activityname":"inserted the data into candidate engagement workflow","modifiedbyuserid":151,"modifiedtime":ISODate("2015-12-01T05:30:00.000+05:30"),"createdbyuserid":151,"createddatetime":ISODate("2015-08-12T00:00:00.000+05:30")},{"firstname":"Vikas Yadav Bhai","middlename":null,"lastname":"Yadav","email":"candidate2@abc.com","activityname":"updated the job details","modifiedbyuserid":151,"modifiedtime":ISODate("2015-12-01T05:30:00.000+05:30"),"createdbyuserid":151,"createddatetime":ISODate("2015-08-12T00:00:00.000+05:30")}]}]}]

db.collection.find({"jobs.activity.email":"candidate1@abc.com","jobs.jobid":12})