Changes between Initial Version and Version 1 of AdminTips

Timestamp:

2011-12-21T21:27:33Z (12 years ago)

Author:

Pan Luo

Comment:

--

AdminTips

@@ +1 @@
+[[PageOutline]]
+
+== Database ==
+
+=== Find student who saved the evaluation but not submit yet ===
+{{{
+#!sql
+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)
+    );
+}}}