##// END OF EJS Templates
Use database LOWER instead of #downcase....
Jean-Philippe Lang -
r11063:8585cda7b1b0
parent child
Show More
@@ -23,10 +23,10 class AutoCompletesController < ApplicationController
23 q = (params[:q] || params[:term]).to_s.strip
23 q = (params[:q] || params[:term]).to_s.strip
24 if q.present?
24 if q.present?
25 scope = (params[:scope] == "all" || @project.nil? ? Issue : @project.issues).visible
25 scope = (params[:scope] == "all" || @project.nil? ? Issue : @project.issues).visible
26 if q.match(/^\d+$/)
26 if q.match(/\A#?(\d+)\z/)
27 @issues << scope.find_by_id(q.to_i)
27 @issues << scope.find_by_id($1.to_i)
28 end
28 end
29 @issues += scope.where("LOWER(#{Issue.table_name}.subject) LIKE ?", "%#{q.downcase}%").order("#{Issue.table_name}.id DESC").limit(10).all
29 @issues += scope.where("LOWER(#{Issue.table_name}.subject) LIKE LOWER(?)", "%#{q}%").order("#{Issue.table_name}.id DESC").limit(10).all
30 @issues.compact!
30 @issues.compact!
31 end
31 end
32 render :layout => false
32 render :layout => false
General Comments 0
You need to be logged in to leave comments. Login now