Posts made by Tim Hunt

Moodle in English -> Quiz and question banks -> Not able to filter questions based on tags -> Re: Not able to filter questions based on tags

by Tim Hunt -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
So, the latest release in that seriese is 4.4.5, and I am pretty sure there have been some bug fixes made in this area. You can check the release notes at https://moodledev.io/general/releases#moodle-44. So really, the best thing to do would be to get your Moodle site upgraded. (That really should be being done anyway, because of the security fixes in each release.)
Average of ratings: -

Moodle in English -> Quiz and question banks -> filtering questions in large question bank -> Re: filtering questions in large question bank

by Tim Hunt -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
This is not currently possible.

Some of might get worked on as part of MDL-83818, but because of how the statistics are stored, I am not sure if it is going to be possible to filter by 'Needs checking' or 'Facility index' with reasonable performance.
Average of ratings: Useful (2)

Moodle in English -> Quiz and question banks -> Multilanguage in Drag and Drop Question -> Re: Multilanguage in Drag and Drop Question

by Tim Hunt -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
Or, upgrade to Moodle 4.5, which includes MDL-78662.

(And, that fix can be successfully added to earlier versions of Moodle. We backported it at the Open University, I think while we were running 4.3, but it might only have been 4.4. If you do, be sure to grab MDL-82832 and MDL-82465 too.)
Average of ratings: -

Moodle in English -> Configurable reports block (plugin) -> Find questions in course categories -> Re: Find questions in course categories

by Tim Hunt -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers

Assuming you are using Moodle 4.0 or later

SELECT *

FROM {question} q
JOIN {question_versions} qv ON qv.questionid = q.id
JOIN {question_bank_entries} qbe ON qbe.id = qv.questionbankentryid
JOIN {question_categories} qc ON qc.id = qbe.questioncategoryid
JOIN {context} ctx ON ctx.id = qc.contextid
JOIN {course_categories} cc ON cc.id = ctx.instanceid AND ctx.contextlevel = 40

WHERE ...
Average of ratings: Useful (4)