Changes between Version 5 and Version 6 of AdvancedReports

Timestamp:

09/26/25 13:44:47 (3 weeks ago)

Author:

226026

Comment:

--

AdvancedReports

@@ -40 +40 @@
 
 {{{
-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[])
+  SELECT * 
+                    FROM v_named_threads t 
+                    WHERE (:title IS NULL OR t.title ILIKE :title || '%') 
+                    AND (CAST(:type as varchar) IS NULL OR t.type ilike :type || '%') 
+                    AND (CAST(:content as varchar) IS NULL OR t.content ILIKE :content || '%')
+                    AND (CAST(:tags as varchar) IS NULL OR t.tags @> string_to_array(lower(:tags),',')::varchar[])
 }}}