Map and filter on some conditoin
Fri Apr 12 2024 03:17:10 GMT+0000 (Coordinated Universal Time)
Saved by @CodeWithSachin #aggregation #mongodb #date #map #filter
http://34.74.16.180:3000/question#eyJkYXRhc2V0X3F1ZXJ5Ijp7InR5cGUiOiJuYXRpdmUiLCJuYXRpdmUiOnsiY29sbGVjdGlvbiI6InN1YnNjcmlwdGlvbiIsInF1ZXJ5IjoiW1xyXG4gICAge1xyXG4gICAgICAgIFwiJG1hdGNoXCI6IHtcclxuICAgICAgICAgICAgXCJzdGFydERhdGVcIjoge1xyXG4gICAgICAgICAgICAgICAgXCIkZ3RlXCI6IHtcclxuICAgICAgICAgICAgICAgICAgICBcIiRkYXRlXCI6IFwiMjAxOC0wMy0xMlQwMzoyNjoyMS45OTdaXCJcclxuICAgICAgICAgICAgICAgIH0sXHJcbiAgICAgICAgICAgICAgICBcIiRsdGVcIjoge1xyXG4gICAgICAgICAgICAgICAgICAgIFwiJGRhdGVcIjogXCIyMDI0LTAzLTEwVDA0OjUwOjM1WlwiXHJcbiAgICAgICAgICAgICAgICB9XHJcbiAgICAgICAgICAgIH1cclxuICAgICAgICB9XHJcbiAgICB9LFxyXG4gICAge1xyXG4gICAgICAgIFwiJGxvb2t1cFwiOiB7XHJcbiAgICAgICAgICAgIFwiZnJvbVwiOiBcInBhcnRpY2lwYW50XCIsXHJcbiAgICAgICAgICAgIFwibG9jYWxGaWVsZFwiOiBcInVzZXJJZFwiLFxyXG4gICAgICAgICAgICBcImZvcmVpZ25GaWVsZFwiOiBcIl9pZFwiLFxyXG4gICAgICAgICAgICBcImFzXCI6IFwicGFydGljaXBhbnREYXRhXCJcclxuICAgICAgICB9XHJcbiAgICB9LFxyXG4gICAge1xyXG4gICAgICAgIFwiJHVud2luZFwiOiBcIiRwYXJ0aWNpcGFudERhdGFcIlxyXG4gICAgfSxcclxuICAgIHtcclxuICAgICAgICBcIiRtYXRjaFwiOiB7XHJcbiAgICAgICAgICAgIFwicGFydGljaXBhbnREYXRhLmVtYWlsXCI6IHtcclxuICAgICAgICAgICAgICAgIFwiJHJlZ3VsYXJFeHByZXNzaW9uXCI6IHtcclxuICAgICAgICAgICAgICAgICAgICBcInBhdHRlcm5cIjogXCJAaml2YS51c2VyXCIsXHJcbiAgICAgICAgICAgICAgICAgICAgXCJvcHRpb25zXCI6IFwiXCJcclxuICAgICAgICAgICAgICAgIH1cclxuICAgICAgICAgICAgfVxyXG4gICAgICAgIH1cclxuICAgIH0sXHJcbiAgICB7XHJcbiAgICAgICAgXCIkbWF0Y2hcIjoge1xyXG4gICAgICAgICAgICBcInBhcnRpY2lwYW50RGF0YS51c2VyU3RhdHVzXCI6IHtcclxuICAgICAgICAgICAgICAgIFwiJG5lXCI6IFwiVEVTVFwiXHJcbiAgICAgICAgICAgIH1cclxuICAgICAgICB9XHJcbiAgICB9LFxyXG4gICAge1xyXG4gICAgICAgIFwiJG1hdGNoXCI6IHtcclxuICAgICAgICAgICAgXCIkYW5kXCI6IFtcclxuICAgICAgICAgICAgICAgIHtcclxuICAgICAgICAgICAgICAgICAgICBcInBhcnRpY2lwYW50RGF0YS5lbWFpbFwiOiB7XHJcbiAgICAgICAgICAgICAgICAgICAgICAgIFwiJG5vdFwiOiB7XHJcbiAgICAgICAgICAgICAgICAgICAgICAgICAgICBcIiRyZWd1bGFyRXhwcmVzc2lvblwiOiB7XHJcbiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgXCJwYXR0ZXJuXCI6IFwiZGVsZXRlZFwiLFxyXG4gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFwib3B0aW9uc1wiOiBcIlwiXHJcbiAgICAgICAgICAgICAgICAgICAgICAgICAgICB9XHJcbiAgICAgICAgICAgICAgICAgICAgICAgIH1cclxuICAgICAgICAgICAgICAgICAgICB9XHJcbiAgICAgICAgICAgICAgICB9LFxyXG4gICAgICAgICAgICAgICAge1xyXG4gICAgICAgICAgICAgICAgICAgIFwicGFydGljaXBhbnREYXRhLmVtYWlsXCI6IHtcclxuICAgICAgICAgICAgICAgICAgICAgICAgXCIkbm90XCI6IHtcclxuICAgICAgICAgICAgICAgICAgICAgICAgICAgIFwiJHJlZ3VsYXJFeHByZXNzaW9uXCI6IHtcclxuICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBcInBhdHRlcm5cIjogXCJAc21pdFxcXFwuZml0JFwiLFxyXG4gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFwib3B0aW9uc1wiOiBcIlwiXHJcbiAgICAgICAgICAgICAgICAgICAgICAgICAgICB9XHJcbiAgICAgICAgICAgICAgICAgICAgICAgIH1cclxuICAgICAgICAgICAgICAgICAgICB9XHJcbiAgICAgICAgICAgICAgICB9XHJcbiAgICAgICAgICAgIF1cclxuICAgICAgICB9XHJcbiAgICB9LFxyXG4gICAge1xyXG4gICAgICAgIFwiJGxvb2t1cFwiOiB7XHJcbiAgICAgICAgICAgIFwiZnJvbVwiOiBcInBhcnRpY2lwYW50QmFzZWxpbmVBbmRGb2xsb3d1cERhdGFcIixcclxuICAgICAgICAgICAgXCJsb2NhbEZpZWxkXCI6IFwidXNlcklkXCIsXHJcbiAgICAgICAgICAgIFwiZm9yZWlnbkZpZWxkXCI6IFwicGFydGljaXBhbnRJZFwiLFxyXG4gICAgICAgICAgICBcImFzXCI6IFwiYmFzZWxpbmVEYXRhXCJcclxuICAgICAgICB9XHJcbiAgICB9LFxyXG4gICAge1xyXG4gICAgICAgIFwiJHVud2luZFwiOiBcIiRiYXNlbGluZURhdGFcIlxyXG4gICAgfSxcclxuICAgIHtcclxuICAgICAgICBcIiRsb29rdXBcIjoge1xyXG4gICAgICAgICAgICBcImZyb21cIjogXCJibG9vZF9nbHVjb3NlXCIsXHJcbiAgICAgICAgICAgIFwibG9jYWxGaWVsZFwiOiBcInVzZXJJZFwiLFxyXG4gICAgICAgICAgICBcImZvcmVpZ25GaWVsZFwiOiBcInBhcnRpY2lwYW50SWRcIixcclxuICAgICAgICAgICAgXCJhc1wiOiBcImdsdWNvc2VEYXRhXCJcclxuICAgICAgICB9XHJcbiAgICB9LFxyXG4gICAge1xyXG4gICAgICAgIFwiJHVud2luZFwiOiBcIiRnbHVjb3NlRGF0YVxcXCIsIFxcXCJwcmVzZXJ2ZU51bGxBbmRFbXB0eUFycmF5c1xcXCIgOiB0cnVlfVwiXHJcbiAgICB9LFxyXG4gICAge1xyXG4gICAgICAgIFwiJHByb2plY3RcIjoge1xyXG4gICAgICAgICAgICBcInN1YnNjcmlwdGlvbklkXCI6IFwiJF9pZFwiLFxyXG4gICAgICAgICAgICBcImJhc2VsaW5lSWRcIjogXCIkYmFzZWxpbmVEYXRhLl9pZFwiLFxyXG4gICAgICAgICAgICBcInVzZXJJZFwiOiAxLFxyXG4gICAgICAgICAgICBcInN0YXJ0RGF0ZVwiOiAxLFxyXG4gICAgICAgICAgICBcInByb2dyYW1TdGFydERhdGVcIjogXCIkYmFzZWxpbmVEYXRhLnByb2dyYW1TdGFydERhdGVcIixcclxuICAgICAgICAgICAgXCJwbGFuQ29kZTFcIjogXCIkc3Vic2NyaXB0aW9uUGxhbi5wcm9ncmFtQ29kZVwiLFxyXG4gICAgICAgICAgICBcImpvdXJuZXlTdGF0dXNcIjogXCIkam91cm5leVRyYWNrZXJPYmplY3Quc3RhdHVzXCIsXHJcbiAgICAgICAgICAgIFwicGxhbkNvZGUyXCI6IFwiJGJhc2VsaW5lRGF0YS5wcm9ncmFtQ29kZVwiLFxyXG4gICAgICAgICAgICBcImZvbGxvd1Vwc1wiOiBcIiRiYXNlbGluZURhdGEuZm9sbG93VXBzXCIsXHJcbiAgICAgICAgICAgIFwiZ2x1Y29zZURhdGFcIjogMVxyXG4gICAgICAgIH1cclxuICAgIH0sXHJcbiAgICB7XHJcbiAgICAgICAgXCIkbWF0Y2hcIjoge1xyXG4gICAgICAgICAgICBcIiRhbmRcIjogW1xyXG4gICAgICAgICAgICAgICAge1xyXG4gICAgICAgICAgICAgICAgICAgIFwiJGV4cHJcIjoge1xyXG4gICAgICAgICAgICAgICAgICAgICAgICBcIiRhbmRcIjogW1xyXG4gICAgICAgICAgICAgICAgICAgICAgICAgICAge1xyXG4gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFwiJGVxXCI6IFtcclxuICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgXCIkcGxhbkNvZGUxXCIsXHJcbiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFwiJHBsYW5Db2RlMlwiXHJcbiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgXVxyXG4gICAgICAgICAgICAgICAgICAgICAgICAgICAgfSxcclxuICAgICAgICAgICAgICAgICAgICAgICAgICAgIHtcclxuICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBcIiRlcVwiOiBbXHJcbiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFwiJHN0YXJ0RGF0ZVwiLFxyXG4gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBcIiRwcm9ncmFtU3RhcnREYXRlXCJcclxuICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBdXHJcbiAgICAgICAgICAgICAgICAgICAgICAgICAgICB9XHJcbiAgICAgICAgICAgICAgICAgICAgICAgIF1cclxuICAgICAgICAgICAgICAgICAgICB9XHJcbiAgICAgICAgICAgICAgICB9XHJcbiAgICAgICAgICAgIF1cclxuICAgICAgICB9XHJcbiAgICB9LFxyXG4gICAge1xyXG4gICAgICAgIFwiJGdyb3VwXCI6IHtcclxuICAgICAgICAgICAgXCJfaWRcIjoge1xyXG4gICAgICAgICAgICAgICAgXCJ1c2VySWRcIjogXCIkdXNlcklkXCIsXHJcbiAgICAgICAgICAgICAgICBcInN0YXJ0RGF0ZVwiOiBcIiRzdGFydERhdGVcIixcclxuICAgICAgICAgICAgICAgIFwicGxhbkNvZGUxXCI6IFwiJHBsYW5Db2RlMVwiXHJcbiAgICAgICAgICAgIH0sXHJcbiAgICAgICAgICAgIFwidXNlcklkXCI6IHtcclxuICAgICAgICAgICAgICAgIFwiJGxhc3RcIjogXCIkdXNlcklkXCJcclxuICAgICAgICAgICAgfSxcclxuICAgICAgICAgICAgXCJiYXNlbGluZUlkXCI6IHtcclxuICAgICAgICAgICAgICAgIFwiJGxhc3RcIjogXCIkYmFzZWxpbmVJZFwiXHJcbiAgICAgICAgICAgIH0sXHJcbiAgICAgICAgICAgIFwic3RhcnREYXRlXCI6IHtcclxuICAgICAgICAgICAgICAgIFwiJGxhc3RcIjogXCIkc3RhcnREYXRlXCJcclxuICAgICAgICAgICAgfSxcclxuICAgICAgICAgICAgXCJwcm9ncmFtU3RhcnREYXRlXCI6IHtcclxuICAgICAgICAgICAgICAgIFwiJGxhc3RcIjogXCIkcHJvZ3JhbVN0YXJ0RGF0ZVwiXHJcbiAgICAgICAgICAgIH0sXHJcbiAgICAgICAgICAgIFwic3Vic2NyaXB0aW9uSWRcIjoge1xyXG4gICAgICAgICAgICAgICAgXCIkbGFzdFwiOiBcIiRzdWJzY3JpcHRpb25JZFwiXHJcbiAgICAgICAgICAgIH0sXHJcbiAgICAgICAgICAgIFwiam91cm5leVN0YXR1c1wiOiB7XHJcbiAgICAgICAgICAgICAgICBcIiRsYXN0XCI6IFwiJGpvdXJuZXlTdGF0dXNcIlxyXG4gICAgICAgICAgICB9LFxyXG4gICAgICAgICAgICBcImZvbGxvd1Vwc1wiOiB7XHJcbiAgICAgICAgICAgICAgICBcIiRsYXN0XCI6IFwiJGZvbGxvd1Vwc1wiXHJcbiAgICAgICAgICAgIH0sXHJcbiAgICAgICAgICAgIFwiZ2x1Y29zZURhdGFcIjoge1xyXG4gICAgICAgICAgICAgICAgXCIkcHVzaFwiOiBcIiRnbHVjb3NlRGF0YVwiXHJcbiAgICAgICAgICAgIH1cclxuICAgICAgICB9XHJcbiAgICB9LFxyXG4gICAge1xyXG4gICAgICAgIFwiJHByb2plY3RcIjoge1xyXG4gICAgICAgICAgICBcInVzZXJJZFwiOiAxLFxyXG4gICAgICAgICAgICBcImJhc2VsaW5lSWRcIjogMSxcclxuICAgICAgICAgICAgXCJzdGFydERhdGVcIjogMSxcclxuICAgICAgICAgICAgXCJwcm9ncmFtU3RhcnREYXRlXCI6IDEsXHJcbiAgICAgICAgICAgIFwic3Vic2NyaXB0aW9uSWRcIjogMSxcclxuICAgICAgICAgICAgXCJqb3VybmV5U3RhdHVzXCI6IDEsXHJcbiAgICAgICAgICAgIFwiZm9sbG93VXBzXCI6IDEsXHJcbiAgICAgICAgICAgIFwiZmllbGRcIjoge1xyXG4gICAgICAgICAgICAgICAgXCIkYWRkXCI6IFtcclxuICAgICAgICAgICAgICAgICAgICBcIiRfaWQuc3RhcnREYXRlXCIsXHJcbiAgICAgICAgICAgICAgICAgICAge1xyXG4gICAgICAgICAgICAgICAgICAgICAgICBcIiRtdWx0aXBseVwiOiBbXHJcbiAgICAgICAgICAgICAgICAgICAgICAgICAgICAxNCxcclxuICAgICAgICAgICAgICAgICAgICAgICAgICAgIDI0LFxyXG4gICAgICAgICAgICAgICAgICAgICAgICAgICAgNjAsXHJcbiAgICAgICAgICAgICAgICAgICAgICAgICAgICA2MCxcclxuICAgICAgICAgICAgICAgICAgICAgICAgICAgIDEwMDBcclxuICAgICAgICAgICAgICAgICAgICAgICAgXVxyXG4gICAgICAgICAgICAgICAgICAgIH1cclxuICAgICAgICAgICAgICAgIF1cclxuICAgICAgICAgICAgfSxcclxuICAgICAgICAgICAgXCJnbHVjb3NlRGF0YVwiOiB7XHJcbiAgICAgICAgICAgICAgICBcIiRmaWx0ZXJcIjoge1xyXG4gICAgICAgICAgICAgICAgICAgIFwiaW5wdXRcIjogXCIkZ2x1Y29zZURhdGFcIixcclxuICAgICAgICAgICAgICAgICAgICBcImFzXCI6IFwiZ2x1Y29zZVwiLFxyXG4gICAgICAgICAgICAgICAgICAgIFwiY29uZFwiOiB7XHJcbiAgICAgICAgICAgICAgICAgICAgICAgIFwiJGFuZFwiOiBbXHJcbiAgICAgICAgICAgICAgICAgICAgICAgICAgICB7XHJcbiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgXCIkbHRcIjogW1xyXG4gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBcIiQkZ2x1Y29zZS5kYXRlXCIsXHJcbiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHtcclxuICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFwiJGFkZFwiOiBbXHJcbiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgXCIkX2lkLnN0YXJ0RGF0ZVwiLFxyXG4gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHtcclxuICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgXCIkbXVsdGlwbHlcIjogW1xyXG4gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgMTQsXHJcbiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAyNCxcclxuICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIDYwLFxyXG4gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgNjAsXHJcbiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAxMDAwXHJcbiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIF1cclxuICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB9XHJcbiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBdXHJcbiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIH1cclxuICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBdXHJcbiAgICAgICAgICAgICAgICAgICAgICAgICAgICB9LFxyXG4gICAgICAgICAgICAgICAgICAgICAgICAgICAge1xyXG4gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFwiJGd0ZVwiOiBbXHJcbiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFwiJCRnbHVjb3NlLmRhdGVcIixcclxuICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgXCIkX2lkLnN0YXJ0RGF0ZVwiXHJcbiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgXVxyXG4gICAgICAgICAgICAgICAgICAgICAgICAgICAgfVxyXG4gICAgICAgICAgICAgICAgICAgICAgICBdXHJcbiAgICAgICAgICAgICAgICAgICAgfVxyXG4gICAgICAgICAgICAgICAgfVxyXG4gICAgICAgICAgICB9XHJcbiAgICAgICAgfVxyXG4gICAgfSxcclxuICAgIHtcclxuICAgICAgICBcIiRwcm9qZWN0XCI6IHtcclxuICAgICAgICAgICAgXCJ1c2VySWRcIjogMSxcclxuICAgICAgICAgICAgXCJiYXNlbGluZUlkXCI6IDEsXHJcbiAgICAgICAgICAgIFwic3RhcnREYXRlXCI6IDEsXHJcbiAgICAgICAgICAgIFwicHJvZ3JhbVN0YXJ0RGF0ZVwiOiAxLFxyXG4gICAgICAgICAgICBcInN1YnNjcmlwdGlvbklkXCI6IDEsXHJcbiAgICAgICAgICAgIFwiam91cm5leVN0YXR1c1wiOiAxLFxyXG4gICAgICAgICAgICBcImZvbGxvd1Vwc1wiOiAxLFxyXG4gICAgICAgICAgICBcImdsdWNvc2VEYXRhXCI6IHtcclxuICAgICAgICAgICAgICAgIFwiJG1hcFwiOiB7XHJcbiAgICAgICAgICAgICAgICAgICAgXCJpbnB1dFwiOiBcIiRnbHVjb3NlRGF0YVwiLFxyXG4gICAgICAgICAgICAgICAgICAgIFwiYXNcIjogXCJvYmpcIixcclxuICAgICAgICAgICAgICAgICAgICBcImluXCI6IHtcclxuICAgICAgICAgICAgICAgICAgICAgICAgXCJwYXJ0aWNpcGFudElkXCI6IFwiJCRvYmoucGFydGljaXBhbnRJZFwiLFxyXG4gICAgICAgICAgICAgICAgICAgICAgICBcInJlYWRpbmdcIjogXCIkJG9iai5yZWFkaW5nXCIsXHJcbiAgICAgICAgICAgICAgICAgICAgICAgIFwiZGF0ZVwiOiBcIiQkb2JqLmRhdGVcIlxyXG4gICAgICAgICAgICAgICAgICAgIH1cclxuICAgICAgICAgICAgICAgIH1cclxuICAgICAgICAgICAgfVxyXG4gICAgICAgIH1cclxuICAgIH1cclxuXSIsInRlbXBsYXRlLXRhZ3MiOnt9fSwiZGF0YWJhc2UiOjJ9LCJkaXNwbGF5IjoidGFibGUiLCJ2aXN1YWxpemF0aW9uX3NldHRpbmdzIjp7fX0=
Comments