Greetings,
This question pertains to retrieving information from the assignments module.
I have these data items:
a) course.id
b) assign.id
c) user.id
1. How can I tell if the assignment was online text, file submission or both? Please provide the SQL query or API to get it, along with additional explanations of code values if they are cryptic or numeric.
2. For a single item submitted by an individual student for a given assignment: What is the SQL or API command to retrieve the online text or the file a student submitted?
3. For multiple items submitted by an individual student for a given assignment: What is the SQL or API command to retrieve ALL the submission objects (online text and / or files) a student submitted?
4. For a single item or multiple items submitted for a group assignment by a representative student: what is the SQL or API command to retrieve all those items?Thank you very much for reading, commenting and helping!