json and wildcard expressions

HI,

I'm new to iReport but am trying to put together a report using a json datasource.  the sections of the data are referenced using a GUID which is generated when the json file is created.  So the data looks something like

{
    "name" : "config1",
    "items" : {
        "e0454dab-e6b3-5fb1-3e68-b242e5f6e48e" :{
            "name" : "item1",
                "information" : "this is the first"
        },
        "2ea24212-c1fc-1650-0442-26c4b43e2053": {
            "name" : "item2",
                "information" : " this is the second"
        },
    },
}

Is there any way of using a wildcard type syntax to get to data, ie items.*.name and create a table from it.

ross.lloyd's picture
Joined: May 16 2013 - 12:38am
Last seen: 10 years 3 weeks ago

1 Answer:

This will be possible in JasperReports Library v6.3.1.

With this release, a new JSON query language(JSONQL) will be available for use. It is meant to replace the existing language for querying JSON data. New sample with extensive documentation will be available in the Data Source / Query Executer section of the sample reference page(http://jasperreports.sourceforge.net/sample.reference.html).

narcism's picture
6038
Joined: Nov 22 2010 - 12:39am
Last seen: 2 hours 56 min ago
Feedback
randomness