Hello,
want to build a SQL query to get a list of all questions in a question bank that is used in a course.
I understand that I could recieve this via the question category but I am struggeling to find the proper tables that I could join to get the relation between a question and the category.
All forum posts are referring to question.categories but this doesn´t seem to exist anymore (the post were pretty old).
Also the documentations here https://docs.moodle.org/dev/Question_database_structure and here https://docs.moodle.org/dev/Quiz_database_structure are telling me that the tables are linked via the category.
The relation must be moved to somewhere else but I can´t find it.
I would be really happy if someone give me a hint in the right direction.
Thanks,
Ingo
-----
Note: My complete goal is to have a query where I can also see if the question is hidden or not and if it is used in any of the quizzes inside a course. Maybe had a similar requirement in the past and can help me out.