Hello everyone,
I'm working on developing a custom program message that is sent out based on users' attendance in seminars within the program. To do this I need to figure out how to form a SQL query that will retrieve the attendance status of a user in the program. Where is this data stored in the database and does anyone have suggestions for how I can retrieve it?
Thanks!
Hi Sam
The data for attendance is stored in the table mdl_factoface_signups this is linked to other tables such as the mdl_user table - see the schema for details of the field names and relationships that you can build your query from.
Regards
Hi Craig,
Thanks for the reply. I should have been more specific though - I'm not just looking for a list of users who have signed up for the event (the attendees), but rather I'm looking for the attendance data for each user after the seminar has occurred. This would be the data on the "Take Attendance" page of the Seminar screen. So I'm trying to figure out, for example, if a user was marked as "Fully attended" or "No show" after the seminar has taken place. Where would I be able to find that information in the database?
Thanks,
Sam
Hi Sam
Thanks for clarifying, the table mdl_facetoface_signup_status has fields statuscode and grade
It looks like a fully attended session has status code of 100 and grade of 100
Partly attended has a status code of 90 and grade of 50
No Show has a status code of 80 and Grade of 0
Can you check this is the same values for you by taking some attendance and looking at the table as this may vary between versions.
Regards
Craig