CONFIGURABLE REPORT

CONFIGURABLE REPORT

by Yamil Hc -
Number of replies: 2

Hi, I'm trying make a reports about, What course have files or informations upload by teachers or what course doesn't have information upload by your teacher? 

I make this query:


SELECT  cs.id, cs.course, cs.section, cs.name AS 'Contenido',

c.shortname, c.fullname, g.name AS 'Grupo'


FROM  mdl_course  AS c

JOIN mdl_course_sections AS cs ON cs.course = c.id

JOIN mdl_groups AS g ON g.courseid = c.id

JOIN mdl_groups_members AS gm ON gm.groupid = g.id


WHERE  cs.name = null

AND g.name LIKE '%VIRT'

OR g.name LIKE '%VIRT1'

OR g.name LIKE '%VIRT2'

OR g.name LIKE '%VIRT3'

OR g.name LIKE '%VIRT4'


But this query doesn't have the correct result, I want to know what's the table have information about the files of a course o what is the correct method to know what course have files or information upload or what not?

Average of ratings: -
In reply to Yamil Hc

Re: CONFIGURABLE REPORT

by AL Rachels -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers

In Moodle, file information is usually in the mdl_files table.

Average of ratings: -
In reply to AL Rachels

Re: CONFIGURABLE REPORT

by Yamil Hc -
Hi, thanks for you answer.
I was looking at the tables and the information I needed is in the "mdl_resource" table and the query was as follows:

SELECT c.shortname, c.fullname, r.id, r.name, r.intro

FROM mdl_course AS c
JOIN mdl_resource AS r ON c.id = r.course
JOIN mdl_groups AS g ON c.id = g.courseid

WHERE g.name LIKE 'VIRT'
OR g.name LIKE 'VIRT1'
OR g.name LIKE 'VIRT2'
OR g.name LIKE 'VIRT3'
OR g.name LIKE 'VIRT4'

#in my case I needed to filter by especific groups of the courses

And it's succefull
Average of ratings: Useful (2)