MongoDB query on multiple fields

Question

I am storing some numbers in mongodb. For e.g.

num1:5
num2:10
num1:11
num2:15

I want to find documents where for e.g. if I pass '7' the query should check if 7 lies between num1 and num2 and must return me this document.

I tried

BasicDBObject query = new BasicDBObject("num1", new BasicDBObject("gte", 7).append("num2",new BasicDBObject("lte", 7)));

and

List<BasicDBObject> obj = new ArrayList<BasicDBObject>();
        obj.add(new BasicDBObject("num1", new BasicDBObject("gte", 7)));
        obj.add(new BasicDBObject("num2", new BasicDBObject("lte", 7)));
        query.put("$and", obj);

Both are not returning me the any result. Could you please let me know correct query for my purpose?

Alex P · Accepted Answer · 2013-08-01 20:02:40Z

7

You forgot to add $ to operators. And I also suggest to use QueryBuilder for this case, it is much more convenient:

DBObject query = QueryBuilder.start("num1").lessThanEquals(7).and("num2").greaterThanEquals(7).get();

I assume that num1 is always not greater than num2 .

answered Aug 1, 2013 at 20:02

Alex P

1,7711 gold badge18 silver badges20 bronze badges

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

1 Comment

Naman Over a year ago

any idea on how to solve the same problem with Filters in mongo 3.3.0 and above?

Collectives™ on Stack Overflow

MongoDB query on multiple fields

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