MongoDB Ruby aggregation with dates

Question

I'm having trouble with the MongoDB ruby driver (via mongoid) using aggregation.

I would like to match against a date using comparison operators.

match = { '$match' => { 'created_at' => { '$gte' => DateTime.parse('2012-08-01') } } }
group = { '$group' => { '_id' => 'foo' } }
MyModel.collection.aggregate([match, group])

I don't know what to put in the first line for the date. The code as written above will throw me an undefined method __bson_dump__ for DateTime exception. Using a string doesn't seem to work, either.

Any suggestions are welcome. MongoID's built in methods give me what I need for the selection but not for the grouping.

score 2 · Accepted Answer · answered Sep 17 '13 at 19:38

2

Figured it out, use a Time object instead of DateTime

match = { '$match' => { 'created_at' => { '$gte' => Time.parse('2012-08-01') } } }

answered Sep 17 '13 at 19:38

David T

765
6
18

1

It is not working, It convert the date to String, which can not be compared to DateTime fields in Mongo – panshul Jul 15 '19 at 17:54

score -2 · Answer 2 · answered Sep 17 '13 at 19:23

-2

Try this.

h = { '$match' => { 'created_at' => { '$gte' => new Date("2012/08/01") } } }

answered Sep 17 '13 at 19:23

usha

28,973
5
72
93

So the code example I gave is ruby, this looks like how we would do it in javascript. – David T Sep 17 '13 at 19:37

MongoDB Ruby aggregation with dates

2 Answers2