wiki:AdminTips

Version 1 (modified by Pan Luo, 12 years ago) ( diff )

--

Database

Find student who saved the evaluation but not submit yet

SELECT * FROM users 
WHERE id IN 
    (SELECT distinct(evaluator) FROM evaluation_mixevals WHERE event_id = EVENTID AND evaluator NOT IN 
        (SELECT distinct(submitter_id) FROM evaluation_submissions WHERE event_id = EVENTID)
    );
Note: See TracWiki for help on using the wiki.