How can we display data from json ( json object is coming from a table field.)?

[sampath.reddy]

Hi,

    I have a table which contain one column as json object of data type BLOB. Now how can i display this jsonobject ( field's) data in ireport ?

    If i display the jsonobject as it is coming from table then it is showing something like [123,34,101,109, . I am not able to understand what it is trying to display. 

    For example the json used in the testing is {"employees":[

    {"firstName":"John", "lastName":"Doe"}, 

    {"firstName":"Anna", "lastName":"Smith"},

    {"firstName":"Peter", "lastName":"Jones"}

]}.

 

   Could anybody help me in finding how to resolve this ?

[lesterlkeyes]

If you mean display it in a human-readable form - you can use json-csv.com to convert it to a spreadsheet.