Sorry I'm neophyte on fabrik.
I add a new list with reference to an existing table. I discovered that the attached field only displays the file name and not the link, so I find out from the old script that the directory was created through a logical function with linking fields. So I created a join between tables in the list, then to make the link to attachments appear, I created this code that I don't understand where I can insert it.
SELECT *, CONCAT('img/atti',a.ctrl,' / ', b.doc_semplice) AS pathPDF FROM `tipi_atti` a, atti b WHERE a.idtipoatto = b.idtipo_atto AND idatto = 25718;
I add a new list with reference to an existing table. I discovered that the attached field only displays the file name and not the link, so I find out from the old script that the directory was created through a logical function with linking fields. So I created a join between tables in the list, then to make the link to attachments appear, I created this code that I don't understand where I can insert it.
SELECT *, CONCAT('img/atti',a.ctrl,' / ', b.doc_semplice) AS pathPDF FROM `tipi_atti` a, atti b WHERE a.idtipoatto = b.idtipo_atto AND idatto = 25718;