Database
[{"_id":ObjectId("5ffef283f1f06ff8524aa2c2"),"applicationName":"TestApp","pName":"","environments":[],"stages":[],"workflows":[[{"pName":"Test1","wName":"TestApp_Test1","agent":""},{"pName":"Test2","wName":"TestApp_Test2","agent":""}],[{"pName":"Test1","wName":"TestApp_Test1","agent":""}]]}]
Query
db.collection.aggregate({"$unwind":"$workflows"},{"$unwind":"$workflows"},{"$match":{"workflows.pName":{"$ne":"Test1"}}},{"$group":{"_id":"$_id",workflows:{$push:"$workflows"},applicationName:{"$first":"$applicationName"}}},{"$group":{"_id":"$_id",workflows:{$push:"$workflows"},applicationName:{"$first":"$applicationName"}}})