I would like to construct an sql query to identify all courses that have uploaded pdfs as a resource. Can anyone assist? I have searched for any 'adhoc database queries' that might suit, but only one addressed identifying pdfs. I've tried to run it but get a zero result, even for courses that have pdfs uploaded using the FILE resource.
I am using Moodle 3.2.2
Thank you. Ruthine