Changes between Version 4 and Version 5 of AdvancedReports

Timestamp:

09/26/25 12:47:14 (3 weeks ago)

Author:

226026

Comment:

--

AdvancedReports

@@ -37 +37 @@
 }}}
 
+== Приказ на сите топици или прокети кои ги задоволовуаат дадените критериуми
 
-
+{{{
+SELECT * 
+FROM v_named_threads t 
+WHERE (:title IS NULL OR t.title LIKE :title || '%') 
+AND (CAST(:type as varchar) IS NULL OR t.type like :type || '%') 
+AND (CAST(:content as varchar) IS NULL OR t.content LIKE :content || '%')
+AND (CAST(:tags as varchar) IS NULL OR t.tags @> string_to_array(:tags,',')::varchar[])
+}}}