mongodb java query where clause for date

Question

I am new to MongoDB and not sure how to achieve the below. One of the document from the collection,

{ 
    "_id" : ObjectId("56cf4cf2997964f0d91aa373"), 
    "id" : "A", 
    "status" : "open", 
    "createdTime" : NumberLong(1456426212898)
}

I would like to fetch data with the following where query,

where - status is open && (createdTime + 10 mins) < currentTime

The below code works for the status. But not sure how to include the time as shown above.

for open `status` - {"status":"open"}

Java code,

    final Bson statusFilter = eq("status", "open");

    final Document projection = new Document();

    final Document sort = new Document();
    sort.append(CREATED_TIME, -1);

    final FindIterable<Document> operation = collection.find(filter).projection(projection).sort(sort);

But not sure, how to achieve ( createdTime + 10 mins) < currentTime.

Thanks

Mansoor · Accepted Answer · 2016-03-01 18:06:59Z

3

It should be

{ $and:[{ "status":"open"},{"createdTime":{$lt:new Date().getTime() - (1000 * 60 * 10)}} ] }

The query is similar to where status=open && createdTime<(currentTime-10mins)

Note: createdTime+10mins < currentTime can be written as createdTime < currentTime-10 mins

edited Mar 1, 2016 at 18:06

answered Mar 1, 2016 at 17:57

Mansoor

1,30411 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1578872 Over a year ago

This answer is accepted. But would like to know how to use the filed in the query like createdTime+10mins.

Collectives™ on Stack Overflow

mongodb java query where clause for date

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related