MongoDB "find" query with multiple query documents

Question

I am using MongoDB 3.2 with Java. I read the documentation and it says to use org.bson.BsonDocument since other options like BSONObject and Document are deprecated. Now, I have query similar to:

db.schools.find({ zipcode: "63109" },
    { students: { $elemMatch: { school: 102 } } } )

I am wondering: how can I write this query in Java?

Note: Here we have two documents inside the find function, while it accepts only single Bson Document or multiple Bson Element(s).

Any help would be appreciated.

Antony Zh · Accepted Answer · 2016-09-11 00:28:11Z

1

Try to use one document for the condition, like db.schools.find({ zipcode: "000000", students: { $elemMatch: { school: 102 }});

EDIT:

So, you are using Projection. In java mongodb driver 3.3 there are: public DBCursor find(DBObject query, DBObject projection). I think you should update your java mongodb driver.

edited Sep 11, 2016 at 0:28

answered Sep 10, 2016 at 23:31

Antony Zh

3122 silver badges10 bronze badges

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

7 Comments

user3925365 Over a year ago

I tried but it returns all the elements of the array which is something I don't want.

Antony Zh Over a year ago

Do you want to query all schools that have 63109 zipcode and in the 'students' array of subdocuments there is any element with 'school' equals 102?

user3925365 Over a year ago

In my case, there is only one school with zipcode as 63109, which has multiple subdocuments in students array out of which i just want one with school as 102.

Antony Zh Over a year ago

In MongoDB you can't query sudocuments. You can query documents only. If you want to query students, you shold move them to their own collection, or filter query results in JAVA

user3925365 Over a year ago

But above query I mentioned is working fine with console, where it gives me the only subdocument I want. So I just want to convert console query to Java.

|

Collectives™ on Stack Overflow

MongoDB "find" query with multiple query documents

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related