Pastie Support Pastie or read my Pastie << self blog

  def auto_complete_for_entity_display_name
    like = '%' + params[:entity][:display_name].downcase + '%'

    if entity_id = params[:entity_id] and entity_type = params[:entity_type]
      conditions = ['id != ? AND entity_type = ? AND LOWER(display_name) LIKE ?',
        entity_id, entity_type, like]
    else
      conditions = ['LOWER(display_name) LIKE ?', like]
    end

    @entities = group_scope(Entity).find(:all,
      :conditions => conditions,
      :order => 'display_name ASC', :limit => 8)

    render :partial => 'auto_complete_for_entity_display_name'
  end