Page 1 of 1

Reading a field with JSON data

Posted: Sun Aug 22, 2021 11:36 am
by jlorue
Hi,
I have built a table in a report based on some text and number fields of a MySQL table, and it is working OK. Let's call it table "A".

But there is one field in that MySQL table that has JSON data (not included in table "A"), and I need to build a specific table within that report ONLY with that JSON data (let's call it table "B").

Is there any possibility to do that?

Re: Reading a field with JSON data

Posted: Tue Aug 24, 2021 12:34 pm
by Lech Kulikowski
Hello,

Unfortunately, directly in the report - no.
You can retrieve data in your code and then register it as DataTable with the RegData() method.

Thank you.