How to use $in operator in mongodb with two fields in java

Question

I would like to retrieve the following information:

select names from database where address like 'colombo' and age>20;

but for MongoDB in Java. Essentially, it should return all names that contain the word colombo ang age greater than 20 in them. I know that there is the $in operator in MongoDB, but how do I do the same in Java, using the Java driver? I've been trying to look for it everywhere but am getting nothing. I've tried:

query = new BasicDBObject("names", new BasicDBObject("$in", "colombo"), new BasicDBObject("age", "$gt20"));

But it didn't worked :( Please help!

$in is used when you are checking if the value lies "IN" the given range. as per your requirement you don't need it. you need AND operator — Sumeet_Pol
– Sumeet_Pol, Commented May 20, 2016 at 12:30

Akhil · Accepted Answer · 2016-05-20 12:54:00Z

4

Try this

BasicDBObject query = new BasicDBObject("names", new BasicDBObject("$in",      Arrays.asList("colombo")));
    query.append("age", new BasicDBObject("$gt", 20));
    FindIterable<Document> find = collection.find(query);
    MongoCursor<Document> iterator = find.iterator();
    Document doc = null;
    while (iterator.hasNext()) {
        doc = iterator.next();
        System.out.println(doc);
    }

answered May 20, 2016 at 12:54

Akhil

1,2843 gold badges22 silver badges46 bronze badges

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

1 Comment

Abba Over a year ago

Somehow this answer does not work for me.. I am using OpenJDK 11 with mongo-java-driver -> version 3.12.5

chridam · Accepted Answer · 2016-05-20 12:47:01Z

0

The $in operator will not be suitable for such as you can only use it to match values that are in an array or to search for documents where the value of a field equals any value in a specified array.

In your case you need a $regex operator to fulfil the query by performing a SQL LIKE operation:

db.collection.find({
    "names": { "$regex": /colombo/, "$options": "i" },
    "age": { "$gt": 20 }
})

or

db.collection.find({
    "names": /colombo/i },
    "age": { "$gt": 20 }
})

which can be implemented in Java as

Pattern pattern = Pattern.compile("colombo", Pattern.CASE_INSENSITIVE);

BasicDBObject query = new BasicDBObject("names", pattern)        
    .append("$age", new BasicDBObject("$gt", 20));
DBCursor result = coll.find(query);

If using the 3.0.x and newer drivers:

Document regx = new Document();
regx.append("$regex", "(?)" + Pattern.quote("colombo"));
regx.append("$options", "i");

Document query = new Document("names", regx).append("$age", new Document("$gt", 20));
FindIterable<Document> iterable = db.getCollection("coll").find(query);

answered May 20, 2016 at 12:47

chridam

104k26 gold badges246 silver badges243 bronze badges

1 Comment

Nima Over a year ago

Thank you very much, it helped me to solve the issue.

Collectives™ on Stack Overflow

How to use $in operator in mongodb with two fields in java

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related