optimise the label query by using cached_label_list instead of joins

2025-10-07 10:58:57 +02:00
1 changed files with 2 additions and 1 deletions
--- a/app/finders/conversation_finder.rb
+++ b/app/finders/conversation_finder.rb
@@ -156,7 +156,8 @@ class ConversationFinder
  def filter_by_labels
    return unless params[:labels]

-    @conversations = @conversations.tagged_with(params[:labels], any: true)
+    pattern = params[:labels].map { |label| Regexp.escape(label) }.join('|')
+    @conversations = @conversations.where('cached_label_list ~ ?', "\\y(#{pattern})\\y")
  end

  def filter_by_source_id