Creating a mongodb query in Java with $or and $in

Question

I am trying to write a java code using mongodb api to create this mongodb query: ``` { "$or": [{"prd" : {"$in" : ["1234", "0987"]}} , {"rsin" : "3228742"}]} ``` Here's the code I am working with so far: ``` QueryBuilder builder = new QueryBuilder(); if (builder == null) { builder = QueryBuilder.start(); } if (mongoKey.equals("prd")){ ArrayList vals = new ArrayList(); for (int i=0; i < prdList; i++){ vals.add(prdList.get(i)); } DBObject obj = new BasicDBObject (mongoKey, new BasicDBObject("$in", vals)); builder.or(obj); }else { builder.and(mongoKey).is(mongoValue); } ``` This is currently printing out the wrong syntax: ``` { "$or": [{"prd" : {"$in" : ["1234", "0987"]}}] , "rsin" : "3228742"} ``` Any help?

Accepted Answer

The problem is on `else` block, you need to use `or` method instead of `and`.

```
...
}else {
    builder.or(new BasicDBObject(mongoKey, mongoValue));
}
```

This will produce the query that you want.

Creating a mongodb query in Java with $or and $in

Solution

Problem