reports_controller.rb

  def autocomplete
    render :json => autocomplete_for_column(params[:column_name])
  end

  def autocomplete_for_column(column_name)
    #zipcode and mls num doesnt work
    valid_names = %w(agentlist_fullname officelist_officename officesell_officename schooldistrict)

    if valid_names.include? column_name
      Property.select(column_name).where("#{column_name} LIKE ?", "%#{params[:q]}%").uniq
    else
      "Error! Column Name Not Allowed!"
    end


  end