Quering date range from mongodb?

[andyww]

I need to query between 2 dates. With mongodb api, I can do:

query.put("plantime", new BasicDBObject("$gte",firstDate).append("$lte", secondDate));

Now with Spring data, I've tried:

Criteria.where("plantime").gte(firstDate).and("plantime").lte(secondDate);

I then received an errorr saying that "plantime" can't occur 2 times in the search. Is there any way to do things similar to "append"? or is there another way to search a range similar to "between"?

[andyww]

Still can't find solution

[aislingvasey]

I had the same issue but this seems to works:

DBObject cond = QueryBuilder.start(PageViewUtil.VIEW_DATE_TIME).greaterThanEquals(start).lessThan(end).get();
Query query = new BasicQuery(cond);

Actually doesn't work that well - the end range is ignored

[albert_kam]

This works :

List<Criteria> timepointCriterias = new ArrayList<>();
timepointCriterias.add(Criteria.where("timepoint").gt(since));
timepointCriterias.add(Criteria.where("timepoint").lte(until));
query.addCriteria(new Criteria().andOperator(
	timepointCriterias.toArray(new Criteria[timepointCriterias.size()]))
);
query.sort().on("timepoint", Order.ASCENDING);

which actually becomes this :

"$and" : [ { "timepoint" : { "$gt" : "2012-07-18"}} , { "timepoint" : { "$lte" : "2012-07-20"}}]

But i am still clueless on the spring mongo code to achieve this :

{"timepoint": {"$gt": "2012-07-18", "$lte": "2012-07-20"}}