Mapping dynamic col into a table

I need to store data as an object/json in MariaDB the stored data in the db looks like this -
[{“sample_id”:“null”},{“sample_id”:“sample_1”}]
When I paste this directly into the input for a table it works fine, however, when I try to query this from the db and run the query data in the table input I am having trouble accessing this and having “sample_id” be the column. Any ideas on how to query this or access the sample_id part of the list column?

Hi Alex,

One way you can solve this is to create a custom column with a calculated value and reference data within the table data object. See the image below for an example:

In your case it might be something like {{ currentRow.lists.sample_id }}

You may also be able to change your table input value to {{ query6.data.lists }} .

Let me know if that helps and happy Retooling!

Chris