On Jun 16, 2:43 pm, Matt Harrison <li...@ruby-forum.com> wrote: > Hi all, > > Haven't played with rails for a while so I'm a little stuck. I've got to > make a search functionality across models. > > Let me try to explain this (sorry for lack of clarity, I've been reading > so many search gems etc that I'm a little fuzzy now): > > * Stores have town and county fields > * Stores has_many Products which each have their own name and level > > Users need to be able to find all Stores (possibily limited by town or > county) which have one or more Products identified by name AND a minimum > level. > > So I might search for Stores which have the Product 'Small Wooden Table' > with a level of at least 4 AND have the Product 'Oak Table' at least > level 10. Then I might restrict that to Stores in the county of > 'Yorkshire'. > > The list of Products is pretty long (300+) and I don't think it would be > user friendly to put them in a long drop-down list, so I'm tempted to > let users type in the name and level manually. If they don't type the > name correctly, then I guess they won't get the right results. >
How big is your data. If you've only got a couple of hundred stores to go with those products then something like Select * from stores Inner join products_stores on store_id = stores.id Inner join products on products.id = product_id Where products.name = 'small wooden table' and level > 4 and location = "yorkshire" Should work. You could loosen the condition on name to make it more user friendly (in which case you might want to chuck a 'distinct' in) or provide an autocomplete for the product name. Beyond a certain point you might fid it better to go for a full blown searchengine like elasticsearch which would make the product name searching bit more powerful while still remaining fast with large amounts of data Fred > I've looked at several gems (including searchlogic and ransack) but none > seem to give me the ability to search related models in this way. I > might have to knock together something from scratch but I don't want to > end up being hideously inefficient. > > Grateful for any pointers on this, and please let me know if I haven't > explained it well enough. > > Many thanks > > -- > Posted viahttp://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
