Json data from a db column
Posted: Mon Jun 12, 2023 5:20 pm
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
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