Eclipse Community Forums: BIRT » query dataset to json

Help

Home

Home » Archived » BIRT » query dataset to json(converting the query dataset to json)

Show: Today's Messages :: Show Polls :: Message Navigator

query dataset to json [message #1779468]

Mon, 08 January 2018 11:12

Steve Warsap

Messages: 1
Registered: January 2018

Junior Member

Hey all

is there an easy way to have a query returned and then converting the actual dataset to json to then use in a report for example

select id, name from table person

then without changing the sql, and before the report loads converting the id, name into json format maybe via java or javascript, using the beforeFactory/afterFactory intialisation.

example return

[{
"id": 1,
"name": "test1"
},
{
"id": 2,
"name": "test2"
},
{
"id": 3,
"name": "test3"
}
]

or manipulated into any necessary format that we need

Cheers in advance

Report message to a moderator

Previous Topic:	RUNTIME: Cannot open the connection for the driver
Next Topic:	What is the lastest build for each JDK?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 08:07:51 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter