Searching Across Multiple Models

Hello All,

I am currently looking for the easiest way to search across multiple
models.

Suppose I am implementing an online inventory look-up system. A user
will search for a product and a list of stores within 10 miles that
have that product in stock will be returned.

I have two models: Store and Product. Store contains all the location
information. Product contains all the product information. Store
has_many Products.

I would imagine that I could carry this query out in two steps: 1)
Retrieve a list of all stores within 10 miles. 2) Search for products
within those stores.

This two-step process seems a little klunky. Is there any better way
to do this efficiently in Rails?

I am using GeoKit to calculate distances.

Thanks in advance,
-Tom

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs