How to do this MongoDB query using java?

Question

I have to write a simple MongoDB query using java but am not able to do it.

The mongo query looks like this:

db.yourCollection.find({"$where" : "this.startDate < this.endDate"})

I have to write the above query using the QueryBuilder class. But am not able to do it in MongoDB java driver.

BasicDBObject document = new BasicDBObject();
document.put("id", 1001);
document.put("intValue", 1200);
document.put("updateValue", 2100);

DBObject query = QueryBuilder.start("intValue").lessThan("updateValue").get();
DBCursor cursor = collection.find(query);
while (cursor.hasNext()) {
System.out.println("Result : -"+cursor.next());}

The above code does not return any results. But if changed to updateValue into 2100 it is giving result. My question here is lessThan takes object as input parameter. Then how can I pass document field as an input parameter?

Rohit Jain · Accepted Answer · 2013-01-14 08:00:31Z

14

Ideally your mongoDB query should be like this: -

db.yourCollection.find({"startDate": {$lt: endDate}})

which can be written in Java like this: -

BasicDBObject query = new BasicDBObject("startDate", new BasicDBObject("$lt", endDate);
DBCursor cursor = coll.find(query);

You can take a look at Official Tutorial

If you want to use QueryBuilder, you can do it like this: -

DBObject query = QueryBuilder.start("startDate").lessThan("endDate").get();
DBCursor cursor = coll.find(query);

edited Jan 14, 2013 at 8:00

answered Jan 14, 2013 at 7:43

Rohit Jain

214k45 gold badges419 silver badges534 bronze badges

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

1 Comment

zulu Over a year ago

The above query builder is not working. if the "endDate" is a field in the same document. It is working if i give the constant value instead of endDate in the QueryBuilder. Moreover the BasicDBObject doesn't accept the endDate field name in thje second parameter

Rahul · Accepted Answer · 2013-01-14 07:44:18Z

QueryBuilder helps construct complex queries to retrieve data from a collection in mongo db. You can use the QueryBuilder like this.

BasicDBObject document = new BasicDBObject();
QueryBuilder qb = new QueryBuilder();
qb.or(new QueryBuilder().put("starting_date").is(null).put("ending_date").is(null).get(),
                new QueryBuilder().put("starting_date").lessThanEquals("ending_date").get());
document.putAll(qb.get());
DBCursor cursor = getDbCollection().find(document)

QueryBuilder qb = new QueryBuilder(), instantiates a new QueryBuilder.
The logic build by the QueryBuilder in the example above is; (starting date = null and ending date = null) or (starting date <=ending date)
document.putAll(qb.get()) adds the logic constructed to the DBObject.

Collectives™ on Stack Overflow

How to do this MongoDB query using java?

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related