I have a companies table and a products table
companies --> id,name,address,owner,country …
products --> id, company_id,name, photo
In my controller I have
@companies=Company.find(:all,:include=>‘products’,:conditions=>["products.name
LIKE '%tool% and company.country=‘spain’ "])
in my view i can show all the companies that have the product
<% for company in @companies %>
<%= company.name %>
<%end%>
and I can show all the products found
<% for product in @companies.products %>
<%= product.name %>
<%end%>
That’s all OK. But now I want to research the list of products under a
new criteria using the previous records found.
@companies.products.find(:all,:conditions=>[‘date>2007-07-05’])
But I get ALL the product with criteria date>2007-07-05 and not just
those who meet both criterias (date criteria and name like ‘%tool%’)
based on the records found previously. How can I do that?