I'm using OpenLMS 3.5 and trying to build a SQL query to generate an admin report with:
Student first name | Last name | Org ID number (custom user profile) | Course name | Completion date
I do not know SQL and for some reason, none of the SQL syntax from the adhoc contributed Moodle reports site works. Obviously I'm doing something wrong or OpenLMS/Moodlerooms requires a slightly different format of those queries? Keep getting the error "The SQL entered is not supported by this report or is incorrect. Error reading from database".
Please, can someone guide me with the SQL query?