I found an even better alternative and I am posting it here, in case someone else might need it.
Essentially, I get the URL page id from one of the fields in my table, so all I needed to do is CONCAT() the URL string with the table element and HTML code
| Code: |
SELECT
posti_reparto.descrizione AS Reparto,
CONCAT('<a rel="lightbox[800 600]" href="index.php?option=com_fabrik&view=details&formid=8&rowid=',datipersonali.con_posto_di_lavoro,'&datipersonali___con_stato_raw=1&resetfilters=1">',posti.titolo_posto,'</a>') AS `Posto di lavoro`, etc., etc.
|
I didn't neet the addon's function, because it will show me the whole link in the table, not an alias that you can click and it can take you to the link.
As you can see, I also integrated lightbox addon (Mediabox CK in this case) so when you click on one of the results, it opens a nice pop-up. The HTML tags are integrated into the page and you can see them if you "inspect element".
