[{"active":true,"name":"CompanyA","contacts":[{"secondary_emails":[],"email":"contact@gmail.com","designation":"VP Cloud & Security","address":"","name":"Ron"}],"services":[{"active":true,"name":"Company Management","title":"Company Helpline","description":"Offering voice, meetings, collaboration and contact center all on one cloud platform.","categories":["SD-WAN","Security and Compliance"],"sub_categories":["Solution"],},{"active":true,"name":"Company HR","title":"Human Resources","description":"Offering HR Services to all","categories":["HR","Company"],"sub_categories":["Solution"],}]}]

db.collection.aggregate([{$unwind:"$services"},{$match:{"services.categories":"SD-WAN"}},{$group:{_id:"$_id",active:{$first:"$active"},name:{$first:"$name"},contacts:{$first:"$contacts"},services:{$addToSet:"$services"}}}])