Changes between Version 5 and Version 6 of WikiStart/AdvancedReports

Timestamp:

01/29/24 13:53:58 (12 months ago)

Author:

133039

Comment:

--

WikiStart/AdvancedReports

@@ -96 +96 @@
 
 == **[[span(style=color: #BF1B1B, 2. Листање(приказ) на таскови за наредните три дена:)]]**
+
+{{{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';
+ }}}}
 
 == **[[span(style=color: #BF1B1B, 3. Листање(приказ) на испити за наредните седум дена:)]]**