Page 1 of 1

Json data from a db column

Posted: Mon Jun 12, 2023 5:20 pm
by zsp
Hi report builders,

I'm new to stimul report.
My report's datasource fetches from a postgres db, the dataset has normal text, date columns and a nested jsonb column that contains the majority of the data.

[{name:"099-00-11", fdate:'2021-12-12', ssdata:{id:'DJK2DLK', date:'2021-12-11',ss:{d1:23,n1:'ok',d2:33,......}},...]

I have fiddled with many actions in the dictionary but none seems to combine these mixed types of data.

Any info/pointer would be appreciated.

Sp

Re: Json data from a db column

Posted: Mon Jun 12, 2023 9:39 pm
by Lech Kulikowski
Hello,

From sql sources, you should retrieve flat tables.

Thank you.