MongoDB Query in Java, search/find in nested object

Question

I'm having a little trouble with a query in Java on a MongoDB.

I have the follow structure in the database:

            {
              "_id" : ObjectId("5059c214707747cbc5819f6f"),
              "id" : "7",
              "title" : "test4",
              "keywords" : "keyword 1, keyword 2",

              "partner" : {
                "id" : "1",
                "name" : "partner",
                "keywords" : "partner keyword 1, partner keyword 2"
              },
              "status" : {
                "id" : "0",
                "name" : "Expired"
              },

              "modified" : "2012-09-27"
            }

I want the query the database for the field 'Status.name', example SELECT * FROM table WHERE status.name = 'Expired'

How would I do such a query in Java for MongoDB?

Thanks for any help or suggestions!

this mongodb.org/display/DOCS/Java+Tutorial looks interesting — Sreenath S
– Sreenath S, Commented Oct 1, 2012 at 9:11

Gianfranco P · Accepted Answer · 2012-10-01 09:26:32Z

Here is an example:

import com.mongodb.Mongo;
import com.mongodb.DBCollection;
import com.mongodb.BasicDBObject;
import com.mongodb.DBCursor;
import com.mongodb.DB;

public class MongoTest {

    public static void main(String[] args) throws Exception {

        // connect to the local database server
        Mongo m = new Mongo();

        DB db = m.getDB( "test" );

        DBCollection coll = db.getCollection("test");

        // delete all the data from the 'test' collection
        coll.drop();

        // make a document
        BasicDBObject doc = new BasicDBObject();

        doc.put("id", 7);
        doc.put("title", "test4");
        doc.put("modified", "2012-09-27");

        BasicDBObject status = new BasicDBObject();

        status.put("id", "1");
        status.put("name", "Expired");

        doc.put("status", status);

        // insert
        coll.insert(doc);

        BasicDBObject query = new BasicDBObject("status.name", "Expired");

        //  run the query and print the results out
        DBCursor cursor = coll.find(query);

        try {
            while (cursor.hasNext()) {
                System.out.println(cursor.next());
            }
        } finally {
            cursor.close();
        }

        m.close();
    }
}

akaIDIOT · Accepted Answer · 2012-10-01 09:16:58Z

4

MongoDB uses a 'match object' as a query. So to find objects that have status.name equal to "Expired", you could feed an object like such:

{ "status.name": "Expired" }

From Java you'll need to create a DBOjbect like the above to use as the match (returning everything that ... matches with the match object) and send that to the database as a query. Assuming you'll have a connection to MongoDB from Java, use the find-method to execute the query you're after.

answered Oct 1, 2012 at 9:16

akaIDIOT

9,2413 gold badges29 silver badges30 bronze badges

Comments

jpllosa · Accepted Answer · 2016-04-03 02:15:37Z

1

With MongoDB Java Driver v3.2.2 you can do something like this:

FindIterable<Document> iterable = collection.find(Document.parse("{\"status.name\": \"Expired\"}"));

This returns all documents containing "Expired" in the status.name nested field.

answered Apr 3, 2016 at 2:15

jpllosa

2,2141 gold badge33 silver badges34 bronze badges

Comments

Robert · Accepted Answer · 2016-03-03 09:52:56Z

0

BasicDBObject query = new BasicDBObject();

List<BasicDBObject> ob = new ArrayList<BasicDBObject>();

ob.add(new BasicDBObject("status.name", "Expired"));

List<BasicDBObject> foundDocument =   table.find(query)into(new ArrayList<BasicDBObject>());

for (int i = 0; i < foundDocument.size(); i++) {

System.out.println(foundDocument.get(i));
}

This will print all the rows having status as "Expired"

edited Mar 3, 2016 at 9:52

Robert

5,31843 gold badges70 silver badges115 bronze badges

answered Mar 3, 2016 at 9:30

Sanchit Singhania

5375 silver badges6 bronze badges

Collectives™ on Stack Overflow

MongoDB Query in Java, search/find in nested object

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related