Retrive a set of documents from array in MongoDB using Java driver

Question

I have a MongoDB document structure like this:

{ 
  "name": "list"
  "config": "default"
  "items": [
    {
      "email": "[email protected]"
      "status": true
      "number": 123
    },
    ...
    {
      "email": "[email protected]"
      "status": false
      "number": 432
    },
   ]
}

Now, how can I retrive multiple subdocuments that much certain criteria. For instance, I want to obtain all documents where status = true. I know that it is possible to use $elemMatch, but it returns only the first matching instance and I need ALL documents that correspond to the specified condition. Please show how can it be done with Java.

$elemMatch does not return only the first mathing instance. It returns all the documents that matched with the given criteria. Check docs again. docs.mongodb.org/manual/reference/operator/elemMatch — Parvin Gasimzade
– Parvin Gasimzade, Commented Sep 11, 2013 at 9:12
Yes, indeed I saw that doc, but in Java I cannot figure out how to do it. Also there is this kind of $elemMatch docs.mongodb.org/manual/reference/projection/elemMatch. I am a little confused how to use it so that I could retrive multiple values. — foma
– foma, Commented Sep 11, 2013 at 9:17
parvin, could you please show the example in Java of how to use $elemMatch to obtain multiple fields. Thanks in advance! — foma
– foma, Commented Sep 11, 2013 at 9:27

Parvin Gasimzade · Accepted Answer · 2013-09-11 11:41:08Z

2

You can do it in Java as follows.

        Mongo mongo = new Mongo("localhost:27017");
        DB db = mongo.getDB("myDB");
        DBCollection coll = db.getCollection("myCollection");

        DBObject statusQuery = new BasicDBObject("status", true);
        DBObject elemMatchQuery = new BasicDBObject("$elemMatch", statusQuery);

        DBObject fields = new BasicDBObject();
        fields.put("items", elemMatchQuery);
        fields.put("name", 1);
        fields.put("config", 1);

        DBCursor cur = coll.find(new BasicDBObject(), fields);

        while (cur.hasNext()) {
            DBObject obj = cur.next();
            // Get fields from object
        }

edited Sep 11, 2013 at 11:41

answered Sep 11, 2013 at 10:20

Parvin Gasimzade

26.1k8 gold badges58 silver badges83 bronze badges

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

3 Comments

foma Over a year ago

parvin, thanks for your answer. Actually, I used the similar idea to do this. However, the problem is still present I launched your code and got the same issue. Now in my "items" array I have only two docs, one with false status and one with true, when I run the code I got both results! But I only need the one with true. Where can be the problem?

Parvin Gasimzade Over a year ago

You want to project your results. I have updated the code above. Check it again.

Muhammad Gelbana Over a year ago

Why is filtering data (i.e. elemMatchQuery) joined with projection data and the filtering data (i.e. fields), while the filtering parameter is a blank object (i.e. new BasicDBObject() in coll.find) !?

trinity · Accepted Answer · 2016-10-31 09:10:39Z

If you want all subdocuments from the list items in separate documents, you can $unwind the list. I also added filter matching status is true:

try (MongoClient client = new MongoClient()) {

        MongoDatabase db = client.getDatabase("myDB");
        MongoCollection<BsonDocument> collection = db.getCollection("myColl", BsonDocument.class);

        MongoCursor<BsonDocument> cursor =
                collection.aggregate(Arrays.asList(new Document("$unwind", "$items"),
                                                    new Document("$match", new Document("items.status", true)))).iterator();

        try {
            while (cursor.hasNext()) {
                // I think this is what you need
                BsonDocument bsonDocument = cursor.next().getDocument("items");

                // and if you just want emails
                String email = bsonDocument.get("email").asString().getValue();
                System.out.println(email);
            }

        } finally {
            cursor.close();
        }
    }

Collectives™ on Stack Overflow

Retrive a set of documents from array in MongoDB using Java driver

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related