General developer forum

[Moodle 3.1] Using Custom SQL reports to obtain all assignment uploads for a user in a course

 
Picture of Matthew Willis
[Moodle 3.1] Using Custom SQL reports to obtain all assignment uploads for a user in a course
 

Hi there!

I need to run an SQL report (via the Configurable Reports plugin for Moodle 3.1) that will return the files a particular student has submitted to all assessable items within a course, including the attempt number and feedback files used by the teacher grader where possible.

In a tree view, I guess it would look like this:

-Student ID: 123456
--Course 1:
---Assessment 1:
----Attempt 1:
-----Submitted File 1.1.a.pdf
-----Submitted File 1.1.b.docx
-----Graded By: TeacherName
----Attempt 2:
-----Submitted File 1.2.a.pdf
-----Submitted File 1.2.b.docx
-----Graded By: TeacherName
---Assessment 2:
----Attempt 1:
-----Submitted File 2.1.a.pdf
-----Submitted File 2.1.b.docx
-----Graded By: TeacherName
----Attempt 2:
-----Submitted File 2.2.a.pdf
-----Submitted File 2.2.b.docx
-----Graded By: TeacherName

Can someone please lead me in the right direction?

Thanks for your time.

Regards,
Matthew


 
Average of ratings: -
Picture of Matthew Willis
Re: [Moodle 3.1] Using Custom SQL reports to obtain all assignment uploads for a user in a course
 

Bump

 
Average of ratings: -
C'est moi :-)
Re: [Moodle 3.1] Using Custom SQL reports to obtain all assignment uploads for a user in a course
Documentation writersParticularly helpful MoodlersTestersTranslators
You'd better ask in the dedicated forum... (or if a moderator can move the thread).

Séverin
 
Average of ratings: -