Rails 3.1 Ransack HABTM

Question

Is HABTM supported by Ransack?

Having the models:

• Shop HABTM Categories
• Category HABTM Shops

Can I use ransack to search a Shop by a single category? What does the form look like?

Answer 1

I think the field you're trying to use would be

:categories_id_eq

Usage would be something like this

<%= f.label :categories_id_eq, "Category" %>
<%= f.collection_select :categories_id_eq, Category.order(:title), :id, :title %>

Answer 2

You should be aware that there are gotchas: while this workds fine

:categories_id_eq

If you want to find products in any category you can go with

:categories_id_in

But if you need to get products belonging to all of categories selected it wont work as expected:

:categories_id_all

returns zero results see discussions:

Rails, Ransack: How to search HABTM relationship for "all" matches instead of "any"

Convert ActiveRecord habtm query to Arel .