How to retrieve data from inner document embedded in array in mongo db using java

Question

public static void main (String args[]) 
    {
        GetMorphiaDB morphia;
        //String id  = request.getParameter("id");
        try {
            morphia = GetMorphiaDB.getInstance();
            Map<String,Object> output = new LinkedHashMap<String, Object>();
            DB db = morphia.getDb();
            DBCollection collection = db.getCollection("Transactions");
            BasicDBObject allQuery = new BasicDBObject();
              BasicDBObject fields = new BasicDBObject();
              fields.put("referenceID", 1);

              /*DBCursor cursor2 = collection.find(allQuery, fields);
              while (cursor2.hasNext()) {
                System.out.println(cursor2.next());
              }*/

              //System.out.println("\n2. Find where number = 5");
              BasicDBObject whereQuery = new BasicDBObject();
              whereQuery.put("referenceID", "E13F31BC80CE");
              fields.put("referenceID", 1);
              //fields.put("listEditions", 1);
              fields.put("listEditions.listInsertion", 1);
              fields.append("_id",false);
              DBCursor curs = collection.find(whereQuery,fields);
              while (curs.hasNext()) {
                System.out.println(curs.next());
              }
} 
        catch (UnknownHostException e) 
        {
            e.printStackTrace();
        } 
        catch (MongoException e) {
            e.printStackTrace();
        }

    }

I have above program which gives me output as below

{ "listEditions" : [ { "listInsertion" : [ { "page" : 2 , "fromDate" : "11/06/2013" , "toDate" : "11/06/2013" , "size" : 240 , "color" : 0 , "colorType" : "All Colour" , "pagePosition" : 2 , "pagePositionType" : "Regular Page" , "sizeDimention" : "12x20" , "width" : 12.0 , "height" : 20.0} , { "page" : 2 , "fromDate" : "11/06/2013" , "toDate" : "11/06/2013" , "size" : 240 , "color" : 0 , "colorType" : "All Colour" , "pagePosition" : 2 , "pagePositionType" : "Regular Page" , "sizeDimention" : "12x20" , "width" : 12.0 , "height" : 20.0}]} , { "listInsertion" : [ { "page" : 2 , "fromDate" : "14/06/2013" , "toDate" : "14/06/2013" , "size" : 240 , "color" : 0 , "colorType" : "All Colour" , "pagePosition" : 2 , "pagePositionType" : "Regular Page" , "sizeDimention" : "12x20" , "width" : 12.0 , "height" : 20.0} , { "page" : 2 , "fromDate" : "14/06/2013" , "toDate" : "14/06/2013" , "size" : 240 , "color" : 0 , "colorType" : "All Colour" , "pagePosition" : 2 , "pagePositionType" : "Regular Page" , "sizeDimention" : "12x20" , "width" : 12.0 , "height" : 20.0}]} , { "listInsertion" : [ { "page" : 2 , "fromDate" : "11/06/2013" , "toDate" : "11/06/2013" , "size" : 240 , "color" : 0 , "colorType" : "All Colour" , "pagePosition" : 2 , "pagePositionType" : "Regular Page" , "sizeDimention" : "12x20" , "width" : 12.0 , "height" : 20.0} , { "page" : 2 , "fromDate" : "11/06/2013" , "toDate" : "11/06/2013" , "size" : 240 , "color" : 0 , "colorType" : "All Colour" , "pagePosition" : 2 , "pagePositionType" : "Regular Page" , "sizeDimention" : "12x20" , "width" : 12.0 , "height" : 20.0}]} , { "listInsertion" : [ { "page" : 2 , "fromDate" : "11/06/2013" , "toDate" : "11/06/2013" , "size" : 240 , "color" : 0 , "colorType" : "All Colour" , "pagePosition" : 2 , "pagePositionType" : "Regular Page" , "sizeDimention" : "12x20" , "width" : 12.0 , "height" : 20.0} , { "page" : 2 , "fromDate" : "11/06/2013" , "toDate" : "11/06/2013" , "size" : 240 , "color" : 0 , "colorType" : "All Colour" , "pagePosition" : 2 , "pagePositionType" : "Regular Page" , "sizeDimention" : "12x20" , "width" : 12.0 , "height" : 20.0}]} , { "listInsertion" : [ { "page" : 2 , "fromDate" : "15/06/2013" , "toDate" : "15/06/2013" , "size" : 240 , "color" : 0 , "colorType" : "All Colour" , "pagePosition" : 2 , "pagePositionType" : "Regular Page" , "sizeDimention" : "12x20" , "width" : 12.0 , "height" : 20.0} , { "page" : 2 , "fromDate" : "15/06/2013" , "toDate" : "15/06/2013" , "size" : 240 , "color" : 0 , "colorType" : "All Colour" , "pagePosition" : 2 , "pagePositionType" : "Regular Page" , "sizeDimention" : "12x20" , "width" : 12.0 , "height" : 20.0}]}] , "referenceID" : "E13F31BC80CE"}

Now I want to fetch values from innerDocument listInsertion which is inside listEditions in [] brackets.

So how to get it.

Jarandinor · Accepted Answer · 2013-06-13 13:44:41Z

1

You can use something like this:

DBObject next = cursor.next();
BasicDBList listEditions = (BasicDBList)next.get("listEditions");
for(Object element: listEditions) {
    BasicDBList listInsertions = (BasicDBList)((BasicDBObject)element).get("listInsertion");
    for(Object lie: listInsertions) {
        System.out.println(lie);
        //System.out.println(((BasicDBObject)lie).get("fromDate"));
    }
}

Add instanceof and other checks if you need.

answered Jun 13, 2013 at 13:44

Jarandinor

1,87616 silver badges8 bronze badges

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

Comments

Brian Agnew · Accepted Answer · 2013-06-13 13:05:46Z

1

That's JSON and you can parse it using a standard JSON library, or map it to a Java object using GSON.

answered Jun 13, 2013 at 13:05

Brian Agnew

273k38 gold badges342 silver badges443 bronze badges

Collectives™ on Stack Overflow

How to retrieve data from inner document embedded in array in mongo db using java

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related