How to implement nested query via Java code for mongoDB

Question

db.a.find({ "id" : { "$in" : db.b.distinct("id") } })

This nested query is workable via shell client.

I'd like to implement it via Java code, but I don't know how. Could anyone please help me?

Divya Gupta · Accepted Answer · 2018-07-25 04:41:25Z

1

Try this

MongoCollection collectionA = database.getCollection("a");

MongoCollection collectionB = database.getCollection("b");

Bson filter1 = new Document("$in", collectionB.distinct("id"));

Bson filter2 = new Document("id",filter1);

List all = collectionA .find(filter2).into(new ArrayList ());

answered Jul 25, 2018 at 4:41

Divya Gupta

262 bronze badges

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

1 Comment

Thanks for your quick reply, I will try this.