Creating report on how many uses of Assignments "Annotate PDF"

Re: Creating report on how many uses of Assignments "Annotate PDF"

by Gregor McNish -
Number of replies: 0
Picture of Particularly helpful Moodlers
If you want to see if annotate pdf is ticked under feedback, something like
select value, count(*) from mdl_assign_plugin_config
where plugin='editpdf'
group by value
should show it-- 1 is ticked, 0 is unticked.

You may want to join against assignment and course_modules as well ot make sure the assignment is visible, the course is visible, etc