Hello!
I've been tasked with pulling submitted rubric data from the Moodle Database, but I'm struggling to find all of the information that I need. I need to pull a table with...
- the student's name
- the rubric/assignment name
- the course name
- criteria description
- remarks (found in mdl_gradingform_rubric_fillings)
- timestamp of submission or modification
For testing purposes, I have a submitted rubric that I'm viewing through the UI so I know exactly what the output should look like for a working query. That rubric has a unique string that I was able to identify in the mdl_gradingform_rubric_fillings table, so I know the data is there. However, I haven't been able to comprehend the linkage necessary to pull in the rest of the required data.
Is it possible to tie in mdl_gradingform_rubric_fillings with the mdl_assign* tables? Or is there another method to querying student name, etc. alongside the remarks?
Any help/advice is greatly appreciated. Thank you.