AnsweredAssumed Answered

SQL Query help please - to pull custom user profile field and course data

Question asked by ps0077505 on Mar 1, 2019


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?