Changes between Version 3 and Version 4 of AdvancedReports

Timestamp:

09/21/25 21:21:21 (36 hours ago)

Author:

225144

Comment:

--

AdvancedReports

@@ -26 +26 @@
 }}}
 
+== Приказ на пријави според во даден топик според даден статус и филтрација на пријавите за секој корисник според новоста
+{{{
+   select *
+            from report r
+            join submission s
+            on s.id = r.id
+            where (:latest is null or (s.created_by,s.created_at) IN ( select created_by,max(created_at) from submission r  group by created_by))
+                        and r.thread_id =:topicId
+                        and (:status is null or s.status=:status)
+}}}
 
+
+