hyper links in reports return text

moodleou / moodle-report_customsql

A Moodle report plugin that lets you easily create simple reports that can be expressed as a single SQL query

48 stars 100 forks source link

hyper links in reports return text #119

Closed ecottis closed 2 years ago

ecottis commented 2 years ago

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

This returns the following:

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 2 years ago

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