When retrieving data from the database / sql, if there is more than one row in a relationship (i.e. 1 to many) table can this be shown on one row rather than creative duplicate rows of the parent record? Such as a group by or concatenate.
Unfortunately our plugin does not support parent/child relations. You can use CONCAT function to merge values inside one column but you cannot create multi-level tables.
When retrieving data from the database / sql, if there is more than one row in a relationship (i.e. 1 to many) table can this be shown on one row rather than creative duplicate rows of the parent record? Such as a group by or concatenate.
Hi Daryl
Thank you for reaching out to us.
Unfortunately our plugin does not support parent/child relations. You can use CONCAT function to merge values inside one column but you cannot create multi-level tables.