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
Json data from a db column
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Json data from a db column
Hello,
From sql sources, you should retrieve flat tables.
Thank you.
From sql sources, you should retrieve flat tables.
Thank you.