custom_auto_complete_controller.rb

class CustomAutoCompleteController < ApplicationController
  unloadable

  before_action :find_project, :authorize

  def search
    @issues = Issue.find_by_sql(["select max(issues.id) as id, custom_values.value as value, count(*) as count from custom_values, issues where custom_values.customized_id = issues.id and custom_values.custom_field_id = ? and lower(custom_values.value) like lower(?) group by custom_values.value order by max(issues.updated_on) desc", params[:custom_field_id], "%#{params[:term]}%"])
    render :layout => false
  end

private
  def find_project
    @project = Project.find(params[:project_id])
  rescue ActiveRecord::RecordNotFound
    render_404
  end 

end