Posts made by Emma Richardson

Moodle in English -> Configurable reports block (plugin) -> Configurable Reports - adding in a filter based on a custom user profile field -> Configurable Reports - adding in a filter based on a custom user profile field

by Emma Richardson -
Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Plugin developers
There are two tables to reference - this was in the help docs...
SELECT *
FROM prefix_user AS u
JOIN prefix_user_info_data AS uid ON uid.userid = u.id
JOIN prefix_user_info_field AS uif ON (uid.fieldid = uif.id AND uif.shortname = 'class')
WHERE `deleted` = "1" and `institution`="your school name" and `department` = "your department" and `data` = "class level and number"
Average of ratings:Useful (1)