Rails gem rails3-jquery-autocomplete how to scope by user

Question

I'm using the Rails gem rails3-jquery-autocomplete to add categories to posts.

I would like to restrict the search to include only categories that belong to the current user or post's author in the results.

The documentation says that I can specify a scope:

:scopes

Added option to use scopes. Pass scopes in an array. e.g :scopes => [:scope1, :scope2]

But I'm not sure how I would pass the user id here?

It seems like a comon scenario, am I missing something obvious?

I found an answer that suggests modifying the get_item method, but that seems to break the auto-complete

Scoping the results for rails3 jquery autocomplete plugin

score 17 · Accepted Answer · edited May 23 '17 at 12:34

17

In posts_controller:

 def get_autocomplete_items(parameters)
    items = super(parameters)
    items = items.where(:user_id => current_user.id)
  end

I'm first calling the original get_autocomplete_items method, and then filtering out the results by current_user.id.

This question helped: Rails 3: alias_method_chain still used?

edited May 23 '17 at 12:34

Community

1
1

answered Aug 30 '11 at 22:12

deb

12,326
21
67
86

1

suppose you're using more than one autocomplete call. Overriding that will foul up all the other autocomplete fields in your view. Hard lesson. Any ideas how to fix – ctilley79 Sep 19 '12 at 03:00
1

@ctilley79 see my answer about your question – Mark Fraser Dec 06 '12 at 06:14

score 8 · Answer 2 · answered Oct 23 '11 at 01:12

I had a similar problem I solved thanks to the answers above.

My autocomplete also worked against a User model, but I needed to restrict the results to the user's institution (Institution has many :users). My controller creates an @institution instance variable that is accessed in the view.

Although the get_autocomplete_items method cannot directly access the instance variable, I found that the data CAN be passed to autocomplete as a parameter (note: I use the simple_forms gem, so the input call looks a little different than the standard rails syntax).

In my view:

<%= f.input :email,  :url => autocomplete_user_email_institutions_path(:institution_id=>@institution.id.to_s), :as => :autocomplete %>

In my controller:

  autocomplete :user, :email, :extra_data => [:first_name, :last_name]

  def get_autocomplete_items(parameters)
    super(parameters).where(:institution_id => params[:institution_id])
  end

My autocomplete list is now scoped to just the users who work for a particular institution.

score 6 · Answer 3 · answered Oct 14 '11 at 07:37

6

deb's answer works for me. The code can be cleaned up a bit:

def get_autocomplete_items(parameters)
  super(parameters).where(:user_id => current_user.id)
end

answered Oct 14 '11 at 07:37

Giuseppe

5,188
4
40
37

score 3 · Answer 4 · answered Jan 06 '15 at 08:57

There is small update to code for those who have having trouble with super method.because of dynamic dispatch it above code need to replaced as below:

def get_autocomplete_items(parameters)
 items = super(parameters)
 items = items.where(searchable: true)
end

to this:

def get_autocomplete_items(parameters)
 items = active_record_get_autocomplete_items(parameters)
 items = items.where(searchable: true)
end

Reference: https://github.com/crowdint/rails3-jquery-autocomplete/issues/278

score 2 · Answer 5 · answered Dec 06 '12 at 06:13

To answer the question posed by @ctilley79, multiple autocompletes is not a problem because, in addition to the possibility of passing more values in the params hash, you also have access to the autocomplete parameters. On my form (as an example), I have both a City and a Zip autocomplete. I need to restrict the City to those in a certain state. So my controller action looks like this:

def get_autocomplete_items(parameters)
  if (parameters[:model] == City)
    super(parameters).where("state_id" => params[:state_id])
  else
    super(parameters)
  end
end

You also have access to the method in case you need it. Do logger.debug on the parameters to see all that is available.

score 1 · Answer 6 · answered Aug 27 '19 at 18:39

I know the gem and the question are old but I found myself using this gem and needing this answer recently... None of the old answers will work anymore because in the source code, the method get_autocomplete_items is generated dynamically and has the ORM prepended on the method name. This is what got it working for me. I assume most folks are using ActiveRecord too but check the autocomplete.rb method 'get_prefix' to figure out what you should prepend to the method name to get it working.

Hope this saves someone a bunch of time. Be the change you want to see and all that ;)

def active_record_get_autocomplete_items(parameters)
  super(parameters).where(id: current_user.id)
end

score 0 · Answer 7 · answered Jan 31 '13 at 02:21

I faced a similar problem. Our site is multi-tenant, so everything needs to be scoped to the tenant.

To make this easier, I modified rails3-jquery-autocomplete to accept another option called :base_scope. It takes a string, that gets eval'd instead of using the model. All the other functionality works, so you can append additional scopes and where clauses if you need to.

My fork is here: https://github.com/GiveCorps/rails3-jquery-autocomplete

I am not sure that the tests i wrote prove it will always work. I just checked that it was using the scope instead of the model in the items method.

i would appreciate any thoughts on it. Not sure whether it merits a pull request.

Rails gem rails3-jquery-autocomplete how to scope by user

7 Answers7

Linked