Filter by HABTM association throws exception

[micapam]

My models Product and Category have a many-to-many relationship via HABTM.

I thought that for products, I could just say:

filter :categories, :as => :check_boxes, :collection => proc { Category.all }

... but this throws an error:

undefined method `category_ids_in' for #MetaSearch::Searches::Product:0x000001079b25c8

How would I get filtering to work for this relationship? I can't specify the bridging table (categories_products) as the source of the collection, because it's a HABTM relationship so there's no such class as CategoryProduct. I don't want to (and shouldn't have to) change my data model.

[akashkamboj]

+1
I second that. Only alternative I could find is creating scopes for the time being.

[phillyslick]

filter :categories_id, :as => :check_boxes

stumbled upon it the other day

[micapam]

That's great - thanks phillyslick.

[thbar]

I get duplicates if I select two categories (although it works!).

Did you guys find a way to dedupe records? (see #982)

[Lordnibbler]

^ still having this issue. #982 above updated in comments with rly shitty workaround :P

[thbar]

thanks :)

[pcreux]

@thbar Did this commit fix it? 2ce2f33

[thbar]

@pcreux dunno yet, I will work again on the admin part in a couple of weeks, I'll report back! Thanks for the heads-up!

[Lordnibbler]

Is this commit merged in master? If so, it did not fix the duplicate results issue for me.

[leonelgalan]

I'm getting the error on 0.4.2 with :as => :select, but not with :as => :check_boxes, it was working before (on 0.4.0, but it stopped working so I updated, but still not working)