diff --git a/app/controllers/auto_completes_controller.rb b/app/controllers/auto_completes_controller.rb index c6de2dd..b00deb3 100644 --- a/app/controllers/auto_completes_controller.rb +++ b/app/controllers/auto_completes_controller.rb @@ -35,7 +35,7 @@ class AutoCompletesController < ApplicationController @issues << scope.find_by_id($1.to_i) end - @issues += scope.where("LOWER(#{Issue.table_name}.subject) LIKE LOWER(?)", "%#{q}%").order(:id => :desc).limit(10).to_a + @issues += scope.like(q).order(:id => :desc).limit(10).to_a @issues.compact! end render :layout => false diff --git a/app/models/issue.rb b/app/models/issue.rb index b61c244..00e9899 100644 --- a/app/models/issue.rb +++ b/app/models/issue.rb @@ -98,6 +98,12 @@ class Issue < ActiveRecord::Base ids.compact! ids.any? ? where(:assigned_to_id => ids) : none } + scope :like, lambda {|q| + q = q.to_s + if q.present? + where("LOWER(#{table_name}.subject) LIKE LOWER(?)", "%#{q}%") + end + } before_validation :clear_disabled_fields before_create :default_assign