Rails query a search result as if it were a table

Question

I'm trying to make an efficient way to search the results of a search. Something like this:

search_results = Product.joins(:product_params).where(product_params: {name: name_a, value: value_a})
# do something to search_results to make it where I can further filter the results based on product_params
search_results = search_results.joins(:product_params).where(product_params: {name: name_b, value: value_b})

• ProductParam and Product are related via belongs_to / has_many.
• name in product_params is indexed.
• There's a large amount of products and product_params, so efficiency is important here.

Answer 1

You can create a database view that you can then query like a model. Here is a link to an article about it. There are lots of resources on the topic that also may be of help :D Rails Database Views