about summary refs log tree commit diff
path: root/app
diff options
context:
space:
mode:
authorPaul Woolcock <paul@woolcock.us>2018-04-10 09:46:27 -0400
committerEugen Rochko <eugen@zeonfederated.com>2018-04-10 15:46:27 +0200
commit8f800ad6917e5fb41d17098f3f860d0d1aedcabe (patch)
treec4325b956152621516715be6965a3c2f32f3dfb6 /app
parent219a4423d8371fc89f122f3ef4874e9121b423f7 (diff)
Change custom emoji search to `ILIKE` instead of `=` (#7099)
Diffstat (limited to 'app')
-rw-r--r--app/models/custom_emoji.rb4
-rw-r--r--app/models/custom_emoji_filter.rb2
2 files changed, 5 insertions, 1 deletions
diff --git a/app/models/custom_emoji.rb b/app/models/custom_emoji.rb
index 476178e86..1ec21d1a0 100644
--- a/app/models/custom_emoji.rb
+++ b/app/models/custom_emoji.rb
@@ -58,5 +58,9 @@ class CustomEmoji < ApplicationRecord
 
       where(shortcode: shortcodes, domain: domain, disabled: false)
     end
+
+    def search(shortcode)
+      where('"custom_emojis"."shortcode" ILIKE ?', "%#{shortcode}%")
+    end
   end
 end
diff --git a/app/models/custom_emoji_filter.rb b/app/models/custom_emoji_filter.rb
index 2c09ed65c..c4bc310bb 100644
--- a/app/models/custom_emoji_filter.rb
+++ b/app/models/custom_emoji_filter.rb
@@ -28,7 +28,7 @@ class CustomEmojiFilter
     when 'by_domain'
       CustomEmoji.where(domain: value)
     when 'shortcode'
-      CustomEmoji.where(shortcode: value)
+      CustomEmoji.search(value)
     else
       raise "Unknown filter: #{key}"
     end