Jump to content
Changes to the Jaspersoft community edition download ×

Jsonql without fields ? using query directly in reports


guigui94

Recommended Posts

Hi 

I wonder how i can achieve this : 

- use of a remote JSON file (WS call)

- no fields configuration since i do not want to loop over them in my report

- search and access json nested objects with jsonql to fill dedicated report area but directly in the report

example: 

in my report i should show

- the parcel ID => as text

- the value of the "value" field fo the rule object found after filtering on "key" == "mindist" => as text

- populate a table wilth th adresses list

 

here is a sample of my json, always one signe "main" root : 
 

{    "main": {        "parcel": {            "id": "10AB01"        },        "rules": [            {                "key": "maxheight",                "value": "20m"            },            {                "key": "mindist",                "value": "2m"            }        ],        "addresses": [            {                "address": "1 King Road",                "key": "park",                "value": "no"            },            {                "address": "2 queen alley",                "key": "park",                "value": "yes"            }        ]    }}[/code]

thanks

 

Guillaume

 

 

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...