Hi, I’m trying to do some aggregation with this adapter GitHub - elixir-mongo/mongodb: MongoDB driver for Elixir · GitHub.

I’m tring to translate this mongo query:

db.trip.aggregate([{$group: {_id : "$city.name", count: {$sum: 1}}}])

That actually works in mongo shell and bring this results:

{ “_id” : { “name” : “City1” }, “count” : 212 }

{ “_id” : { “name” : “City2” }, “count” : 1200 }

{ “_id” : { “name” : “City3” }, “count” : 789 }

{ “_id” : { “name” : “City4” }, “count” : 540 }

{ “_id” : { “name” : “City5” }, “count” : 333 }

I’m tryin’ to use Mongo.aggregate but I don’t have clear the sintax, could anyone help me with this?

The set up of the lib is ok, I have some find queries and works find and I can render the responses correctly, It’s just I cannot figure it out how do I have to write the aggregate sentences with this adapter.

Thanks in advance.