Changes between Version 12 and Version 13 of WikiStart/AdvancedReports

Timestamp:

01/29/24 16:08:03 (12 months ago)

Author:

121232

Comment:

--

WikiStart/AdvancedReports

@@ -100 +100 @@
 DECLARE correct_student_id INT;
 SET correct_student_id = 11111;
-SELECT t.*
-FROM task t
-JOIN dashboard_task dt ON t.task_id = dt.task_id
-JOIN dashboard d ON dt.student_id = d.student_id
-JOIN calendar_event ce ON d.dashboard_date = ce.event_start_time::date
-WHERE d.student_id = chosen_student_id
- AND ce.event_start_time BETWEEN CURRENT_DATE AND CURRENT_DATE + INTERVAL '3 days';
+
+SELECT 
+    t.task_name,
+    t.task_description,
+    t.task_date,
+    t.task_priority
+FROM 
+    task AS t
+JOIN 
+    student_task AS st ON t.task_id = st.task_id
+JOIN 
+    creates_task AS ct ON t.task_id = ct.task_id
+JOIN 
+    subject_at_term AS sat ON ct.term_subject_id = sat.term_subject_id
+        AND ct.term_type = sat.term_type 
+        AND ct.starting_year = sat.starting_year
+        AND ct.finishing_year = sat.finishing_year
+        AND ct.student_id = sat.student_id
+WHERE 
+    st.student_id = correct_student_id 
+    AND t.task_date BETWEEN CURRENT_DATE AND CURRENT_DATE + INTERVAL '3 days'
+ORDER BY 
+    t.task_priority;
 }}}