hi
I have setup a grid that is showing the data ok. When I click on the plus to open the subgrid there is no data but the headings are shown.

The query is returned ok and works ok in mysql. the json data is returned ok (below) but there is no data showing.

Can anyone help please

Query is SELECT l.`No`,l.`Category`, l.`lens` FROM `Lens` i INNER JOIN `lines` l ON i.`No` = l.`No` and i.`Category` = l.`Category` WHERE i.No = '1' and l.`Category` = 'st'
[{"No":"1","Category":"st","lens":"stlens1"},{"No":"1","Category":"st","lens":"stlens2"}]