jeroen / mongolite

Fast and Simple MongoDB Client for R
https://jeroen.github.io/mongolite/
286 stars 65 forks source link

$group problem with aggregation #135

Closed rstewarting closed 6 years ago

rstewarting commented 6 years ago

I am running an aggregation successfully in Studio 3T. Running the following statement through mongolite though, returns zero documents:

mc5613 <- abcdata$aggregate('[ {"$match" : {"payload.AccountId" : 5613.0}}, {"$group" : {"_id" : "$payload._Id", "count" : {"$sum" : 1.0}}}]')