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

Moodle.org

This discussion has been locked so you can no longer reply to it.

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 ?

Average of ratings: -

by Davo Smith - Thursday, 9 November 2017, 7:46 PM

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.

Average of ratings: -

General developer forum