Parse error on aggregation query.

[Rob Moore]

I've created an aggregation query which includes the following:

 .and(String.format("{ $match: { codingDates: { $gte: ISODate('%s') } } }", startDate)) // startDate is a Joda LocalDate

When I try to execute the query, I'm seeing the following:

java.lang.IllegalArgumentException: Cannot parse query: { $match: { codingDates: { $gte: ISODate('2010-08-06') } } }
 at org.jongo.query.BsonQueryFactory.createQuery(BsonQueryFactory.java:162)
 at org.jongo.Aggregate.and(Aggregate.java:50)

The query works in the MongoDB shell and I'm puzzled to why I'm seeing the exception. Any ideas?

Thanks,

Rob

P.S. I tried using the templating approach prior to using String.format but nothing is returned. I suspect that the query is issued with the hash value left unmodified in that case. 

[Benoît GUEROUT]

Hello,

You should query with $date operator, it should look something like this "{ $match: { codingDates: { $gte: { '$date' : #} } } }"

You can find a working example here https://github.com/bguerout/jongo/blob/9344e72177687cb35df07181527a7beac1f47b03/src/test/java/org/jongo/marshall/DocumentMarshallingTest.java#L129

[Rob Moore]

Thanks, Benoît. I haven't used the $date operator before. 

Based on these docs, it looks like it's fair to say that Jongo supports strict mode rather than shell mode.

[Benoît GUEROUT]

Indeed this is the strict mode syntax.

We will add an information about that in doc.

On Thursday, May 12, 2016 at 5:05:30 PM UTC+2, Rob Moore wrote: