Rails and Searchlogic: finding products that matching all given product categories by using searchlo

Posted by Roland on Stack Overflow See other posts from Stack Overflow or by Roland
Published on 2010-03-25T15:02:35Z Indexed on 2010/03/25 15:03 UTC
Read the original article Hit count: 520

Filed under:

ruby-on-rails

|

searchlogic

|

habtm

I have a model Publication and a model Category in my Rails app. Both are connected with a has_and_belongs_to_many association.

Now I would like to search publications that match one or more categories. If more than one category is given they have all assigned to the publication. I want to specify the categories in a multiple select_box.

Publication.released.categories_id_is([1,2]) is not working because the categories are connected with OR.

With Publication.categories_id_is_all([1,2]) the categories are connected with AND, but no result is given back.

Any idea's on that? Am I mising the right point in the docs. Thanks for your very welcome help!

© Stack Overflow or respective owner

Related posts about ruby-on-rails

Ruby on Rails - How can I start? [closed]

as seen on Programmers - Search for 'Programmers'
I have misconception in understanding the relationship between Ruby language and Ruby on Rails Framework. Because of 'I am an absolute beginner' in web development I have no idea if I have to grasp the fundamentals of Ruby before I go with Ruby on Rails! I also want to ask who is behind both Ruby… >>> More
DES3 decryption in Ruby on Rails

as seen on Stack Overflow - Search for 'Stack Overflow'
My RoR server receives a string, that was encrypted in C++ application using des3 with base64 encoding The cipher object is created so: cipher = OpenSSL::Cipher::Cipher::new("des3") cipher.key = key_str cipher.iv = iv_str key_str and iv_str: are string representations of key and initialization… >>> More
Ruby on rails: Image downloads with Authentication/Authorization/Time outs

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi Guys, I'm having few doubts on implementing file downloads. I'm creating an app where I use attachment_fu with Amazon s3 to upload files. Things are working pretty well so far on uploading side. Now its the time to start the file downloads. Here is what I need, a logged in user search and browse… >>> More
Ruby on Rails deployment, on "thin" server with lot of attachments

as seen on Stack Overflow - Search for 'Stack Overflow'
A lot of PDFs are stored inside MySQL as a BLOB field for each PDF file. The average file size is 500K each. The Rails app will stream the :binary data as file downloads, where there is a user click on the download link. Assume there is a maximum of 5 users downloading 5 PDFs concurrently, what… >>> More
Apply Behavior Driven Development to Ruby on Rails with Rspec

as seen on Internet.com - Search for 'Internet.com'
Applying the Behavior Driven Development (BDD) methodology to your Rails development takes you beyond traditional Test Driven Development. Learn how to do it with the Ruby-based BDD framework RSpec. >>> More

Related posts about searchlogic

Rails and Searchlogic: finding products that matching all given product categories by using searchlo

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a model Publication and a model Category in my Rails app. Both are connected with a has_and_belongs_to_many association. Now I would like to search publications that match one or more categories. If more than one category is given they have all assigned to the publication. I want to specify… >>> More
Search by price interval in currency and other params using Searchlogic

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I need to reaqlize search in product model with prices in different currencies (price and currecny_id field). Every currency have own rate. When user search for product in price range [x, y] USD, range must be converted to all currencies and return values like (price > from_eur AND price… >>> More
Searchlogic cannot sort search result

as seen on Stack Overflow - Search for 'Stack Overflow'
Imagine a code: search = Project.search( :title_or_description_or_child_name_or_child_age_or_inspiration_or_decorating_style_or_favorite_item_or_others_like_any => keys, :galleries_id_like_any => @g, :styles_id_like_any => @st, :tags_like_any => @t ) search.all returns the rows… >>> More
ruby on rails, searchlogic and refactoring

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey all, I'mt not too familiar with searchlogic plugin for rails (I did view the railscasts but wasn't helpful in relation to the specific code below). Can anyone briefly describe how it is being used in the three methods below? Thanks for any response. def extract_order @order_by = if params[:order]… >>> More
Rails, searchlogic choose categories with checkboxes

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I am useing searchlogic to search some paintings. Each painting belong to a single category. What I would like to do is add multiple checkboxes to my search form, so that users can mark multiple categories. (joined with or) Is this possible with searchlogic? The query I am looking for is something… >>> More