MongoDB Java driver edit a cursor after it has been retrieved -


in mongodb java driver retrieve documents query.

dbcursor cursor = dbcollection.find(query).sort(new basicdbobject("date", -1));   return json.serialize(cursor); 

this works fine returns following:

{        "issuccessful": true,        "result": [           {              "date": {                 "$date": "2014-11-26t23:00:00.000z"              },              value: 20           }        ]     } 

but: want edit field $date using

simpledateformat 

i've tried this:

dbcursor cursor = dbcollection.find(query).sort(new basicdbobject("date", -1)); while(cursor.hasnext()){     dbobject dbo = cursor.next();     dbo.put("date", simpledate.format(dbo.get("date"))); } return json.serialize(cursor); 

but while loop doesn't affect returned result.
gives same result back. how change date field , return it? i've put following line:

simpledate.format(dbo.get("date")) 

in system.out.printline("");
, prints out "27-11-2014", want it.

i solved doing following:

dbcursor cursor = dbcollection.find(query).sort(new basicdbobject("date", -1));     list<dbobject> arr = new arraylist<dbobject>();     while(cursor.hasnext()){         dbobject dbo = cursor.next();         dbo.put("date", simpledate.format(dbo.get("date")));         arr.add(dbo);     }     return json.serialize(arr); 

summary: pass every dbobject cursor while loop, here edit simpledateformat

simpledate simpledateformat("dd-mm-yyyy") object  

then, put every item in arraylist, serialize json.serialize, return javascript.


Comments

Popular posts from this blog

javascript - Any ideas when Firefox is likely to implement lengthAdjust and textLength? -

matlab - "Contour not rendered for non-finite ZData" -

delphi - Indy UDP Read Contents of Adata -