we're using Moodle 3.11.4 and the latest release of ad-hoc Report 4.1.
We want to show a link in the report with the text Link. Right now we are using the folling SELECT statement:
CONCAT("%%WWWROOT%%/mod/assign/view.php%%Q%%id=",cm.id, "&action=grading") AS "Link"
This states shows:
as a link and we can open it. But what we want is:
and this should be clickable to open the selected page. I#ve read in the documentation that the folling statement should work:
CONCAT('<a target="_blank" href="%%WWWROOT%%/mod/assign/view.php%%Q%%id=',cm.id, '&action=grading">Link</a>') AS "Link"