Date Range Query with java driver is not returning any results

[gurupre...@gmail.com]

Using mongodb java driver to do the range query on dates.

Had the following data under collection named "TestData".

{

    "_id" : ObjectId("5491d8c2bd6e045d05a40b98"),

    "eventId" : "1",

   "createdDate" : ISODate("2014-12-18T00:37:23.810Z")

}

Formulated the following db query through java driver, but it is not returning any results. 

db.TestData.aggregate({ "$match" : { "createdDate" : { "$gte" : { "$date" : "2012-12-18T00:37:23.810Z"} , "$lte" : { "$date" : "2015-02-18T00:37:23.810Z"}}}});

Tested on both mongodb(2.6.50  and mongo driver (2.12.3, 2.13.0-rc0)

Thanks

[Will Berkeley]

Can you show the Java code for running the problematic query? The query is correctly formatted in strict mode MongoDB extended JSON, and it matches the example document. Where did the query come from? Java driver logging?

-Will

[gurupre...@gmail.com]

Hi Will,

Used '"yyyy-MM-dd'T'HH:mm:ss.SSS'Z'"  format to store the dates into db.

Using the following code for querying. date1 and date2 are java.util.date objects.

   queryBuilder.put(searchKey).greaterThanEquals(date1).lessThanEquals(date2);


public List query(Criteria criteria, String storeName) {
   List<DBObject> dbCriterias = getCriterias(criteria);
   printQuery(dbCriterias, storeName);
   AggregationOutput output = dbCollection.aggregate( dbCriterias);
   List results = output.results();
   return results;
}


// Prints the query so that it can be verified in client tools
//Date queries may not work in some tools if they support only javascript as they need isodate instead of the generated one.
public void printQuery(List<DBObject> criterias, String storeName) {
         if(criterias != null && !criterias.isEmpty() ) {
             System.out.println("\n pipelineOps:" + " db." + storeName + ".aggregate(" +  
                criterias.toString().substring(1,  criterias.toString().length() - 1 ) + ");");
         }
 }

Thanks
Moksh

[Asya Kamsky]

You say:

Used '"yyyy-MM-dd'T'HH:mm:ss.SSS'Z'"  format to store the dates into db.

But that's a string and not a date so it won't match a query on date range.

--
You received this message because you are subscribed to the Google Groups "mongodb-user"
group.
 
For other MongoDB technical support options, see: http://www.mongodb.org/about/support/.
---
You received this message because you are subscribed to the Google Groups "mongodb-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mongodb-user...@googlegroups.com.
To post to this group, send email to mongod...@googlegroups.com.
Visit this group at http://groups.google.com/group/mongodb-user.
To view this discussion on the web visit https://groups.google.com/d/msgid/mongodb-user/2b06fb1f-06c9-48e7-8ef5-b0b2f031a9f7%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.