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



    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 ?
sampath.reddy's picture
Joined: Jan 2 2014 - 10:09pm
Last seen: 3 years 3 months ago

1 Answer:


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

lesterlkeyes's picture
Joined: Aug 9 2014 - 8:21pm
Last seen: 6 years 1 month ago