Nested Object from mysql source?

[michaelrwright]

When setting comments I get the correct amount of comments in count but they have no data just empty grey boxes. Is there something missing to use this feature with mysql data source

Grafana v11.4.0 (b58701869e)
Business Table Version 2.0.0

Query A

select *,
(select json_arrayagg(tc.c_id) as c_id
from mani_IT.test_comments tc
where tc.comment_id = td.id
) as comment
from mani_IT.test_devices td
order by td.id

nested Object query

SELECT *
FROM mani_IT.test_comments
WHERE c_id IN (${payload.ids:csv});

Data Settings filled in

[michaelrwright]

This seems to work when setting my nested object query to the below. I'm not sure how it works but each row selects the correct comments.

once the data settings are filled out it populates

SELECT * 
FROM mani_IT.test_comments