2015년 1월 2일 금요일

JasperSoft Mongodb Query

{
 'collectionName':'base',
 'findQuery':
            {
             "_id" : { "$oid" : "$P!{baseid}"}
            }
}



Hi i have json like this.

"marks":{
"sem1" :{
"mark1":10,
"total":100
},
"sem2":{
"mark2":20,
"total":200
},
"sem3":{
"mark2":30,
"total":300
}
}

I need result  like 

mark  total   sem

10    100     sem1 
20    200     sem2
30    300     sem3

how can i get above format using mongodb query.Query is jaspersoft related means very useful



Could you clarify by telling us how you are going to use the document/table? It's unclear exactly what you want to accomplish from the formatted table.


댓글 없음:

댓글 쓰기