CODEWITHSUNDEEP
javamongodbmongodb-query
update0412
update0412

Reputation: 33

How to implement nested query via Java code for mongoDB

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?

Upvotes: 0

Views: 45

Answers (1)

Divya Gupta
Divya Gupta

Reputation: 26

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 ());

Upvotes: 1

Related Questions