General developer forum

How to exclude deleted quiz in sql query

 
Picture of Ebin Manuval
How to exclude deleted quiz in sql query
 

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: -
Davo
Re: How to exclude deleted quiz in sql query
Core developersParticularly helpful MoodlersPlugin developers

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: -