moodleou/moodle-report_customsql

hyper links in reports return text

ecottis opened this issue · 1 comments

ecottis commented

Hi

For some reason reports do not convert url links from text the code is:

image

This returns the following:
image

I'm running on Moodle 4.0.3 and using the latest version of moodle-report_customsql

Any support or solution would be greatly appreciated

timhunt commented

Read the instructions on the form where you edit the query.

SELECT
    c.shortname,
    c.shortname AS Course_Name,
    CONCAT('%%WWWROOT/course/view.php%%Q%%id=', c.id) AS Course_Name_link_url,
    --- and so on