Moodle in English: How to exclude deleted quiz in sql query

General developer forum

How to exclude deleted quiz in sql query

This discussion has been locked because a year has elapsed since the last post. Please start a new discussion topic.

I need select quiz regarding specific course so I used this query

SELECT * FROM moodle_amsg_2017.mdl_quiz where course=4;

but it also select deleted quizzes in that course, how can i exclude those deleted quizzes.

I haven't seen any is_deleted flag in db. Any idea ?

When a quiz is deleted, the entry in the mdl_quiz table should also be deleted (specifically, by this line of code: https://github.com/moodle/moodle/blob/master/mod/quiz/lib.php#L205 ).

If that is not happening, then there is a bug on your system that needs investigating.