SQL To Get List of Files Used By a Course

Re: SQL To Get List of Files Used By a Course

by fares kaya -
Number of replies: 1

I had used this query to find all files by idcourse

but it didn't work.

I don't find the relation between instanceid and idcourse?

(moodle: 2.4)

Average of ratings: -
In reply to fares kaya

Re: SQL To Get List of Files Used By a Course

by Karikalan Kumaresan -

Hi,

I would like to write a SQL to get the list of files and folders in the course (using course id) in alphabetical order. I tried with few examples, but it was not successful, can you please help me with the same?

Thanks,

Kari...

Average of ratings: -