Database

[{"images":["image-16533778099618.jpg","image-16558883260220.jpg","image-16558883261740.jpg"],"published":true,"_id":"628c8b113cb8f7065f8e6949","user":{"role":"super_admin","_id":"622606af0f40cb8ea37383dc","firstName":"super","lastName":"admin","email":"super@amin.com","countryCode":90,"phoneNumber":5315737502,"password":"$2b$10$NmPKrFZktwJAJiHjLupMOeIQ./jxVWrh7w7IK6j1vMVuTAzhirbBa","address":[],"createdAt":"2022-03-07T13:20:47.420Z","updatedAt":"2022-03-07T13:20:47.420Z","__v":0},"name":"زانو 2 بنکن","description":"بنکن وارداتی","price":60000,"categories":"624b59639807f3b39ee58fce","filters":[{"_id":"628c8b113cb8f7065f8e694a","parent":"628381fb4777683a81224ac2","value":"628381fb4777683a81224ac3","name":"Fitting Type"},{"_id":"628c8b113cb8f7065f8e694b","parent":"628384734777683a81224ad6","value":"628384734777683a81224ad7","name":"Material"},{"_id":"628c8b113cb8f7065f8e694c","parent":"6283852d4777683a81224af4","value":"6283852d4777683a81224afc","name":"Size I"},{"_id":"628c8b113cb8f7065f8e694d","parent":"6283866c4777683a81224b57","value":"6283866c4777683a81224b5b","name":"Schedule / Class"},{"_id":"628c8b113cb8f7065f8e694e","parent":"628387324777683a81224b8f","value":"628387324777683a81224b90","name":"END Type"}],"subFilter":[],"createdAt":"2022-05-24T07:36:49.899Z","updatedAt":"2022-06-22T08:58:46.225Z","__v":0,"discount":10},{"images":["image-16557019270048.jpg"],"published":true,"_id":"62b001a6d03c6051aaab6c91","user":{"role":"super_admin","_id":"622606af0f40cb8ea37383dc","firstName":"super","lastName":"admin","email":"super@amin.com","countryCode":90,"phoneNumber":5315737502,"password":"$2b$10$NmPKrFZktwJAJiHjLupMOeIQ./jxVWrh7w7IK6j1vMVuTAzhirbBa","address":[],"createdAt":"2022-03-07T13:20:47.420Z","updatedAt":"2022-03-07T13:20:47.420Z","__v":0},"name":"لوله بدون درز 2 اینچ اهواز","description":"لوله مانسمان اهواز ","price":1600000,"categories":"624b5aa79807f3b39ee58ff6","filters":[{"_id":"62b001a6d03c6051aaab6c92","parent":"628391614777683a81224c01","value":"628391614777683a81224c02","name":"Pipe Type"},{"_id":"62b001a6d03c6051aaab6c93","parent":"6283921f4777683a81224c07","value":"6283921f4777683a81224c08","name":"Material Standard"},{"_id":"62b001a6d03c6051aaab6c94","parent":"628392fb4777683a81224c27","value":"628392fb4777683a81224c30","name":"Size(NPS)"},{"_id":"62b001a6d03c6051aaab6c95","parent":"628393864777683a81224c4f","value":"628393864777683a81224c53","name":"Schedule"},{"_id":"62b001a6d03c6051aaab6c96","parent":"628394844777683a81224c74","value":"628394844777683a81224c75","name":"Lengh(m)"}],"subFilter":[],"createdAt":"2022-06-20T05:12:06.946Z","updatedAt":"2022-06-20T05:13:19.323Z","__v":0,"discount":null},{"images":["image-16557020912400.jpg","image-1655702091334x.jpg"],"published":true,"_id":"62b0024bd03c6051aaab6caa","user":{"role":"super_admin","_id":"622606af0f40cb8ea37383dc","firstName":"super","lastName":"admin","email":"super@amin.com","countryCode":90,"phoneNumber":5315737502,"password":"$2b$10$NmPKrFZktwJAJiHjLupMOeIQ./jxVWrh7w7IK6j1vMVuTAzhirbBa","address":[],"createdAt":"2022-03-07T13:20:47.420Z","updatedAt":"2022-03-07T13:20:47.420Z","__v":0},"name":"شیر کشویی 1 اینچ","description":"","price":800000,"categories":"6246f5bc9807f3b39ee58f2b","filters":[{"_id":"62b0024bd03c6051aaab6cab","parent":"628341404777683a81224266","value":"628355234777683a81224407","name":" Valve Type"},{"_id":"62b0024bd03c6051aaab6cac","parent":"6283418b4777683a81224268","value":"6283441c4777683a812242ae","name":"Material Type"},{"_id":"62b0024bd03c6051aaab6cad","parent":"628353eb4777683a812243ef","value":"628354c74777683a812243f4","name":"TRIM MATERIAL"},{"_id":"62b0024bd03c6051aaab6cae","parent":"628355044777683a812243ff","value":"628355044777683a81224404","name":"End conection"},{"_id":"62b0024bd03c6051aaab6caf","parent":"628357074777683a81224412","value":"628357074777683a81224416","name":"Size"},{"_id":"62b0024bd03c6051aaab6cb0","parent":"628357bd4777683a8122453f","value":"6283581a4777683a81224560","name":"Class/Prussure "},{"_id":"62b0024bd03c6051aaab6cb1","parent":"6283586a4777683a8122456a","value":"6283586a4777683a8122456b","name":"Operation"}],"subFilter":[{"_id":"62b0024bd03c6051aaab6cb2","parent":"6283418b4777683a81224268","value":"62834adb4777683a81224316","title":"Body Material"}],"createdAt":"2022-06-20T05:14:51.164Z","updatedAt":"2022-06-20T05:14:58.938Z","__v":0,"discount":null},{"images":["image-1655702512690M.jpeg"],"published":true,"_id":"62b003f0d03c6051aaab6cbd","user":{"role":"super_admin","_id":"622606af0f40cb8ea37383dc","firstName":"super","lastName":"admin","email":"super@amin.com","countryCode":90,"phoneNumber":5315737502,"password":"$2b$10$NmPKrFZktwJAJiHjLupMOeIQ./jxVWrh7w7IK6j1vMVuTAzhirbBa","address":[],"createdAt":"2022-03-07T13:20:47.420Z","updatedAt":"2022-03-07T13:20:47.420Z","__v":0},"name":"شیر توپی 2 اینچ پیشگام","description":"با مدارک","price":4300000,"categories":"62445c4d922d127512867246","filters":[{"_id":"62b003f0d03c6051aaab6cbe","parent":"6264307f19636d7db1804b77","value":"626430bb19636d7db1804b78","name":"Valve Type "},{"_id":"62b003f0d03c6051aaab6cbf","parent":"6264319819636d7db1804b7b","value":"6264319819636d7db1804b7e","name":"Body Type "},{"_id":"62b003f0d03c6051aaab6cc0","parent":"626431ef19636d7db1804b82","value":"626431ef19636d7db1804b83","name":"Bore Type "},{"_id":"62b003f0d03c6051aaab6cc1","parent":"6264328519636d7db1804b85","value":"6264328519636d7db1804b86","name":"Material Type"},{"_id":"62b003f0d03c6051aaab6cc2","parent":"626435de19636d7db1804c10","value":"626439b619636d7db1804ca7","name":"Ball / Trim Material"},{"_id":"62b003f0d03c6051aaab6cc3","parent":"6264367919636d7db1804c17","value":"6264367919636d7db1804c18","name":"End Conection"},{"_id":"62b003f0d03c6051aaab6cc4","parent":"626436a719636d7db1804c1f","value":"6264378119636d7db1804c28","name":"Size"},{"_id":"62b003f0d03c6051aaab6cc5","parent":"6264389219636d7db1804c6d","value":"6264389219636d7db1804c6f","name":"Class / Pressure"},{"_id":"62b003f0d03c6051aaab6cc6","parent":"628358e64777683a8122457b","value":"628358e64777683a8122457c","name":"Operation"}],"subFilter":[{"_id":"62b003f0d03c6051aaab6cc7","parent":"6264328519636d7db1804b85","value":"626433b919636d7db1804b93","title":"Body Material"}],"createdAt":"2022-06-20T05:21:52.624Z","updatedAt":"2022-06-20T05:22:02.963Z","__v":0,"discount":null},{"images":["image-1655888546324M.jpeg"],"published":true,"_id":"62b00433d03c6051aaab6cd2","user":{"role":"super_admin","_id":"622606af0f40cb8ea37383dc","firstName":"super","lastName":"admin","email":"super@amin.com","countryCode":90,"phoneNumber":5315737502,"password":"$2b$10$NmPKrFZktwJAJiHjLupMOeIQ./jxVWrh7w7IK6j1vMVuTAzhirbBa","address":[],"createdAt":"2022-03-07T13:20:47.420Z","updatedAt":"2022-03-07T13:20:47.420Z","__v":0},"name":"شیر توپی 2 اینچ کیتز","description":"","price":1400000,"categories":"62445c4d922d127512867246","filters":[{"_id":"62b00433d03c6051aaab6cd3","parent":"6264307f19636d7db1804b77","value":"626430bb19636d7db1804b78","name":"Valve Type "},{"_id":"62b00433d03c6051aaab6cd4","parent":"6264319819636d7db1804b7b","value":"6264319819636d7db1804b7e","name":"Body Type "},{"_id":"62b00433d03c6051aaab6cd5","parent":"626431ef19636d7db1804b82","value":"626431ef19636d7db1804b83","name":"Bore Type "},{"_id":"62b00433d03c6051aaab6cd6","parent":"6264328519636d7db1804b85","value":"6264328519636d7db1804b86","name":"Material Type"},{"_id":"62b00433d03c6051aaab6cd7","parent":"626435de19636d7db1804c10","value":"6264363319636d7db1804c11","name":"Ball / Trim Material"},{"_id":"62b00433d03c6051aaab6cd8","parent":"6264367919636d7db1804c17","value":"6264367919636d7db1804c18","name":"End Conection"},{"_id":"62b00433d03c6051aaab6cd9","parent":"626436a719636d7db1804c1f","value":"6264378119636d7db1804c28","name":"Size"},{"_id":"62b00433d03c6051aaab6cda","parent":"6264389219636d7db1804c6d","value":"6264389219636d7db1804c6f","name":"Class / Pressure"},{"_id":"62b00433d03c6051aaab6cdb","parent":"628358e64777683a8122457b","value":"628358e64777683a8122457c","name":"Operation"}],"subFilter":[{"_id":"62b00433d03c6051aaab6cdc","parent":"6264328519636d7db1804b85","value":"626433b919636d7db1804b93","title":"Body Material"}],"createdAt":"2022-06-20T05:22:59.707Z","updatedAt":"2022-06-22T09:02:26.421Z","__v":0,"discount":null},]

Query

db.collection.find({categories:"62445c4d922d127512867246",$or:[{filters:{"$elemMatch":{value:"626430bb19636d7db1804b78",name:"Valve Type "}}},{filters:{"$elemMatch":{value:"6264328519636d7db1804b86",name:"Material Type"}}},{filters:{"$elemMatch":{"value":"6264363319636d7db1804c11","name":"Ball / Trim Material"}}}]})

Result