[{"_id":{"$oid":"5ee3fc20f0d85d517c605001"},"name":"Asian Brisket","images":["IMAGE_RECIPES-f9f5c18f-80b3-4e89-b351-ca5b667d5f8f.jpeg","IMAGE_RECIPES-f9f5c18f-80b3-4e89-b351-ca5b667d5f8f.jpeg","IMAGE_RECIPES-f9f5c18f-80b3-4e89-b351-ca5b667d5f8f.jpeg"],"status":"ACTIVE","description":"Brioche,Brisket Pastrami,Miyagi Mayo@@","partnerId":"5e536a7f218e20267f0ead29","restaurantId":"5e537245fb96c700018c4615","catalogItems":[{"_id":{"$oid":"5e5791486ebdf6000104e001"},"name":"ING Brioche bun","type":"INGREDIENT","catalogParent":"MODIFIER","modifierId":"22a694ab-8506-4a4b-a831-579fba64a001","qty":1,"status":"ACTIVE","recipeId":"5e53972ffb96c700018c4621","recipeName":"Brisket Bun*"},{"_id":{"$oid":"5e5791486ebdf6000104e001"},"name":"ING Brioche bun","type":"INGREDIENT","catalogParent":"MODIFIER","modifierId":"e2710b98-6681-4533-a33d-b3317e0a8002","qty":1,"status":"ACTIVE","recipeId":"5e53972ffb96c700018c4621","recipeName":"Brisket Bun*"},{"_id":{"$oid":"5e5791486ebdf6000104e002"},"name":"ING Smoked brisket pastrami","type":"INGREDIENT","catalogParent":"MODIFIER","modifierId":"22a694ab-8506-4a4b-a831-579fba64a001","qty":150,"status":"ACTIVE","recipeId":"5e53972ffb96c700018c4621","recipeName":"Brisket Bun*"},{"_id":{"$oid":"5e5791486ebdf6000104e002"},"name":"ING Smoked brisket pastrami","type":"INGREDIENT","catalogParent":"MODIFIER","modifierId":"81ae819a-2b78-4df5-8122-d05d2eddd003","qty":150,"status":"ACTIVE","recipeId":"5e53972ffb96c700018c4621","recipeName":"Brisket Bun*"},{"_id":{"$oid":"5e5791486ebdf6000104e003"},"name":"ING cheddar cheese","type":"INGREDIENT","catalogParent":"MODIFIER","modifierId":"22a694ab-8506-4a4b-a831-579fba64a001","qty":10,"status":"ACTIVE","recipeId":"5e53972ffb96c700018c4621","recipeName":"Brisket Bun*"}],"recipe":{"_id":{"$oid":"5e53972ffb96c700018c4001"},"name":"Brisket Bun*","description":"Brioche bun, Smoked brisket pastrami, Pickles, Caramelized Onions, Carnaise Sauce, Mustard*","status":"INACTIVE","preparedMethod":"1 PC BRIOCHE BUN,\n1 SERVING BRISKET PASTRAMI,\n10 GMS CHEDDAR CHEESE,\n25 GMS CARAMELIZED ONION,\n60 GMS CARNAISE SAUCE,\n7 GMS BUTTER\n\n","preparationTime":22,"partnerId":"5e536a7f218e20267f0ead29","restaurantId":"5e537245fb96c700018c4615"},"modifiers":[{"_id":"22a694ab-8506-4a4b-a831-579fba64a001","recipeId":"5e53972ffb96c700018c4621","groupId":"abb141ba-3e89-460a-a710-4a546187f001","groupName":"Select your extra Item","recipeName":"Brisket Bun*","displayName":"Mac And Cheese","qty":1,"status":"ACTIVE"},{"_id":"e2710b98-6681-4533-a33d-b3317e0a8002","recipeId":"5e53972ffb96c700018c4621","groupId":"abb141ba-3e89-460a-a710-4a546187f002","groupName":"Select your extra Item","recipeName":"Brisket Bun*","displayName":"Chedder Cheese ","qty":1,"status":"ACTIVE"},{"_id":"81ae819a-2b78-4df5-8122-d05d2eddd003","recipeId":"5e53972ffb96c700018c4621","groupId":"abb141ba-3e89-460a-a710-4a546187f003","groupName":"Select your extra Item","recipeName":"Brisket Bun*","displayName":"Pickles","qty":1,"status":"ACTIVE"}],"version":0,"createdDate":{"$date":"2020-06-12T22:05:19.618Z"},"lastModifiedDate":{"$date":"2020-06-12T22:05:19.618Z"},"createdBy":"User","lastModifiedBy":"User","_class":"com.grubtech.service.kds.document.MenuItem"},{"_id":{"$oid":"5ee3fc20f0d85d517c605002"},"name":"Asian Brisket","images":["IMAGE_RECIPES-f9f5c18f-80b3-4e89-b351-ca5b667d5f8f.jpeg","IMAGE_RECIPES-f9f5c18f-80b3-4e89-b351-ca5b667d5f8f.jpeg","IMAGE_RECIPES-f9f5c18f-80b3-4e89-b351-ca5b667d5f8f.jpeg"],"status":"ACTIVE","description":"Brioche,Brisket Pastrami,Miyagi Mayo@@","partnerId":"5e536a7f218e20267f0ead29","restaurantId":"5e537245fb96c700018c4615","catalogItems":[{"_id":{"$oid":"5e5791486ebdf6000104e001"},"name":"ING Brioche bun","type":"INGREDIENT","catalogParent":"MODIFIER","modifierId":"22a694ab-8506-4a4b-a831-579fba64a001","qty":1,"status":"ACTIVE","recipeId":"5e53972ffb96c700018c4621","recipeName":"Brisket Bun*"},{"_id":{"$oid":"5e5791486ebdf6000104e001"},"name":"ING Brioche bun","type":"INGREDIENT","catalogParent":"MODIFIER","modifierId":"e2710b98-6681-4533-a33d-b3317e0a8002","qty":1,"status":"ACTIVE","recipeId":"5e53972ffb96c700018c4621","recipeName":"Brisket Bun*"},{"_id":{"$oid":"5e5791486ebdf6000104e002"},"name":"ING Smoked brisket pastrami","type":"INGREDIENT","catalogParent":"MODIFIER","modifierId":"22a694ab-8506-4a4b-a831-579fba64a001","qty":150,"status":"ACTIVE","recipeId":"5e53972ffb96c700018c4621","recipeName":"Brisket Bun*"},{"_id":{"$oid":"5e5791486ebdf6000104e002"},"name":"ING Smoked brisket pastrami","type":"INGREDIENT","catalogParent":"MODIFIER","modifierId":"81ae819a-2b78-4df5-8122-d05d2eddd003","qty":150,"status":"ACTIVE","recipeId":"5e53972ffb96c700018c4621","recipeName":"Brisket Bun*"},{"_id":{"$oid":"5e5791486ebdf6000104e003"},"name":"ING cheddar cheese","type":"INGREDIENT","catalogParent":"MODIFIER","modifierId":"22a694ab-8506-4a4b-a831-579fba64a001","qty":10,"status":"ACTIVE","recipeId":"5e53972ffb96c700018c4621","recipeName":"Brisket Bun*"},{"_id":{"$oid":"5e5791486ebdf6000104e004"},"name":"ING Caramelized onions","type":"INGREDIENT","catalogParent":"RECIPE","qty":25,"status":"ACTIVE","recipeId":"5e53972ffb96c700018c4621","recipeName":"Brisket Bun*"},{"_id":{"$oid":"5e5791486ebdf6000104e005"},"name":"ING carnaise sauce","type":"INGREDIENT","catalogParent":"RECIPE","qty":60,"status":"ACTIVE","recipeId":"5e53972ffb96c700018c4621","recipeName":"Brisket Bun*"},{"_id":{"$oid":"5e5791486ebdf6000104e005"},"name":"carnaise sauce","type":"INGREDIENT","catalogParent":"RECIPE","qty":60,"status":"ACTIVE","recipeId":"5e53972ffb96c700018c4621","recipeName":"Brisket Bun*"}],"recipe":{"_id":{"$oid":"5e53972ffb96c700018c4002"},"name":"Brisket Bun*","description":"Brioche bun, Smoked brisket pastrami, Pickles, Caramelized Onions, Carnaise Sauce, Mustard*","status":"INACTIVE","preparedMethod":"1 PC BRIOCHE BUN,\n1 SERVING BRISKET PASTRAMI,\n10 GMS CHEDDAR CHEESE,\n25 GMS CARAMELIZED ONION,\n60 GMS CARNAISE SAUCE,\n7 GMS BUTTER\n\n","preparationTime":22,"partnerId":"5e536a7f218e20267f0ead29","restaurantId":"5e537245fb96c700018c4615"},"modifiers":[{"_id":"22a694ab-8506-4a4b-a831-579fba64a001","recipeId":"5e53972ffb96c700018c4621","groupId":"abb141ba-3e89-460a-a710-4a546187f001","groupName":"Select your extra Item","recipeName":"Brisket Bun*","displayName":"Mac And Cheese","qty":1,"status":"ACTIVE"},{"_id":"e2710b98-6681-4533-a33d-b3317e0a8002","recipeId":"5e53972ffb96c700018c4621","groupId":"abb141ba-3e89-460a-a710-4a546187f002","groupName":"Select your extra Item","recipeName":"Brisket Bun*","displayName":"Chedder Cheese ","qty":1,"status":"ACTIVE"},{"_id":"81ae819a-2b78-4df5-8122-d05d2eddd003","recipeId":"5e53972ffb96c700018c4621","groupId":"abb141ba-3e89-460a-a710-4a546187f003","groupName":"Select your extra Item","recipeName":"Brisket Bun*","displayName":"Pickles","qty":1,"status":"ACTIVE"}],"version":0,"createdDate":{"$date":"2020-06-12T22:05:19.618Z"},"lastModifiedDate":{"$date":"2020-06-12T22:05:19.618Z"},"createdBy":"User","lastModifiedBy":"User","_class":"com.grubtech.service.kds.document.MenuItem"}]

db.collection.aggregate([{"$unwind":"$catalogItems"},{"$match":{"catalogItems.name":{"$regex":"^ING Smoked brisket","$options":"i"}}},{"$group":{"_id":{"_id":"$catalogItems._id","name":"$catalogItems.name","status":"$catalogItems.status"},"modIds":{"$addToSet":"$catalogItems.modifierId"},"recipeList":{"$addToSet":{"_id":{$toString:"$recipe._id"},"name":"$recipe.name","menuId":"$recipe.menuId","status":"$recipe.status","modifiers":"$modifiers"}}}},{$project:{_id:"$_id._id",name:"$_id.name",status:"$_id.status",recipeList:{$map:{input:"$recipeList",as:"recipe",in:{id:"$$recipe._id",name:"$$recipe.name",status:"$$recipe.status",menuId:null,modifiers:{$map:{input:{$filter:{input:"$$recipe.modifiers",as:"modif",cond:{$in:["$$modif._id","$modIds"]}}},as:"mod",in:{id:"$$mod._id",recipeId:"$$mod.recipeId",displayName:"$$mod.displayName",status:"$$mod.status"}}}}}}}}])