thiscodeWorks - Organizing the best of code online

List view

#aggregation #mongodb #$converter #elemmatch #elem #match #$elemmatch

[
    {
        "$match": {
            "mealPlan": {
                "$elemMatch": {
                    "portionMeasure": "Tea Spoon",
                    "dishVariation": "Paneer Paratha"
                }
            }
        }
    },
    {
       $count:"toatal"
    }
]

#aggregation #mongodb #$converter

$converter - converting data type

[
    {
        "$match": {
            "participantId": ObjectId("65c4d2bbd566b4251df9209f")
        }
    },
    {
        "$match": {
            "date": {
                "$gte": ISODate("2024-01-31T18:30:00Z"),
                "$lte": ISODate("2024-02-29T18:29:00Z")
            },
            "src": {
                "$ne": "manual"
            }
        }
    },
    {
        "$group": {
            "_id": "$participantId",
            "totalSteps": {
                "$sum": {
                    "$convert": {
                        "input": "$stepsTaken",
                        "to": "double",
                        "onError": 0,
                        "onNull": 0
                    }
                }
            }
        }
    },
    {
        "$project": {
            "_id": 0,
            "participantId": "$_id",
            "totalSteps": 1
        }
    }
]

elem match operator

Wed Jun 26 2024 17:26:58 GMT+0000 (Coordinated Universal Time) http://34.74.16.180:3000/question#eyJkYXRhc2V0X3F1ZXJ5Ijp7ImRhdGFiYXNlIjo2NSwibmF0aXZlIjp7ImNvbGxlY3Rpb24iOiJwYXJ0aWNpcGFudERpZXRNZWFsUGxhbkRldGFpbHMiLCJxdWVyeSI6IltcclxuICAgIHtcclxuICAgICAgICBcIiRtYXRjaFwiOiB7XHJcbiAgICAgICAgICAgIFwibWVhbFBsYW5cIjoge1xyXG4gICAgICAgICAgICAgICAgXCIkZWxlbU1hdGNoXCI6IHtcclxuICAgICAgICAgICAgICAgICAgICBcInBvcnRpb25NZWFzdXJlXCI6IFwiVGVhIFNwb29uXCIsXHJcbiAgICAgICAgICAgICAgICAgICAgXCJkaXNoVmFyaWF0aW9uXCI6IFwiUGFuZWVyIFBhcmF0aGFcIlxyXG4gICAgICAgICAgICAgICAgfVxyXG4gICAgICAgICAgICB9XHJcbiAgICAgICAgfVxyXG4gICAgfSxcclxuICAgIHtcclxuICAgICAgICRjb3VudDpcInRvYXRhbFwiXHJcbiAgICB9XHJcbl1cclxuIiwidGVtcGxhdGUtdGFncyI6e319LCJ0eXBlIjoibmF0aXZlIn0sImRpc3BsYXkiOiJ0YWJsZSIsInZpc3VhbGl6YXRpb25fc2V0dGluZ3MiOnt9fQ==

#aggregation #mongodb #$converter #elemmatch #elem #match #$elemmatch

$converter - converting data type

Fri Jun 21 2024 04:26:48 GMT+0000 (Coordinated Universal Time) http://34.74.16.180:3000/question#eyJkYXRhc2V0X3F1ZXJ5Ijp7InR5cGUiOiJuYXRpdmUiLCJuYXRpdmUiOnsiY29sbGVjdGlvbiI6InN0ZXBzIiwicXVlcnkiOiJbXHJcbiAgICB7XHJcbiAgICAgICAgXCIkbWF0Y2hcIjoge1xyXG4gICAgICAgICAgICBcInBhcnRpY2lwYW50SWRcIjogT2JqZWN0SWQoXCI2NWM0ZDJiYmQ1NjZiNDI1MWRmOTIwOWZcIilcclxuICAgICAgICB9XHJcbiAgICB9LFxyXG4gICAge1xyXG4gICAgICAgIFwiJG1hdGNoXCI6IHtcclxuICAgICAgICAgICAgXCJkYXRlXCI6IHtcclxuICAgICAgICAgICAgICAgIFwiJGd0ZVwiOiBJU09EYXRlKFwiMjAyNC0wMS0zMVQxODozMDowMFpcIiksXHJcbiAgICAgICAgICAgICAgICBcIiRsdGVcIjogSVNPRGF0ZShcIjIwMjQtMDItMjlUMTg6Mjk6MDBaXCIpXHJcbiAgICAgICAgICAgIH0sXHJcbiAgICAgICAgICAgIFwic3JjXCI6IHtcclxuICAgICAgICAgICAgICAgIFwiJG5lXCI6IFwibWFudWFsXCJcclxuICAgICAgICAgICAgfVxyXG4gICAgICAgIH1cclxuICAgIH0sXHJcbiAgICB7XHJcbiAgICAgICAgXCIkZ3JvdXBcIjoge1xyXG4gICAgICAgICAgICBcIl9pZFwiOiBcIiRwYXJ0aWNpcGFudElkXCIsXHJcbiAgICAgICAgICAgIFwidG90YWxTdGVwc1wiOiB7XHJcbiAgICAgICAgICAgICAgICBcIiRzdW1cIjoge1xyXG4gICAgICAgICAgICAgICAgICAgIFwiJGNvbnZlcnRcIjoge1xyXG4gICAgICAgICAgICAgICAgICAgICAgICBcImlucHV0XCI6IFwiJHN0ZXBzVGFrZW5cIixcclxuICAgICAgICAgICAgICAgICAgICAgICAgXCJ0b1wiOiBcImRvdWJsZVwiLFxyXG4gICAgICAgICAgICAgICAgICAgICAgICBcIm9uRXJyb3JcIjogMCxcclxuICAgICAgICAgICAgICAgICAgICAgICAgXCJvbk51bGxcIjogMFxyXG4gICAgICAgICAgICAgICAgICAgIH1cclxuICAgICAgICAgICAgICAgIH1cclxuICAgICAgICAgICAgfVxyXG4gICAgICAgIH1cclxuICAgIH0sXHJcbiAgICB7XHJcbiAgICAgICAgXCIkcHJvamVjdFwiOiB7XHJcbiAgICAgICAgICAgIFwiX2lkXCI6IDAsXHJcbiAgICAgICAgICAgIFwicGFydGljaXBhbnRJZFwiOiBcIiRfaWRcIixcclxuICAgICAgICAgICAgXCJ0b3RhbFN0ZXBzXCI6IDFcclxuICAgICAgICB9XHJcbiAgICB9XHJcbl1cclxuIiwidGVtcGxhdGUtdGFncyI6e319LCJkYXRhYmFzZSI6Mn0sImRpc3BsYXkiOiJ0YWJsZSIsInZpc3VhbGl6YXRpb25fc2V0dGluZ3MiOnt9fQ==

#aggregation #mongodb #$converter

elem match operator

$converter - converting data type

Save snippets that work with our extensions