Alberto asked 3 years ago
Hi Abu,
Hope you are keeping well.
I’m implementing the subgrid – master grid feature.
I’m having a bit of an issue; the subgrid is not showing the records.
I’m triggering the subgrid in a button. It seems that the results of the query of the select command for the subgrid does not carry the results into the grid.
I’ve sent you an email with details and resources.
It would be great if you could have a quick look at it.
Thank you and kind regards,
Alberto.
Abu Ghufran Staff answered 3 years ago
I tried to regenerate the grid with running db scripts but still it still needs join tables data.
I’d suggest to follow the query debugging steps.
1) open the grid showing button to open subgrid
2) goto code and before ‘$m->table = “btsRequest”;’ put phpgrid_error($m->select_command);
3) goto browser, open debug console > network tab (f12) and click on button to open subgrid, It will show the select_command in error box
Try running that query in sql editor and see if it works.
We can also have a remote session via google meet or remotedesktop.
PS: Use forum for a question unless you are sharing some confidential code / details.
