Json data from a db column

[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

[Lech Kulikowski]

Hello,

From sql sources, you should retrieve flat tables.

Thank you.