easiest and fastest way is to keep number of reviews in column in
product table... then simple add :order => 'reviews_count desc' in your
Product.find()
tom
Robert Scott wrote:
> Hi! I hope someone can offer some insight or direction into a problem
> I'm having.
>
> In my application, I have two tables: products and reviews.
>
> - Products stores information on things that are sold
> - Reviews store comments from users that purchased the product, as well
> as boolean field about if they would purchase again.
>
> The models are setup so that products has_many reviews and reviews
> belong_to their respective products.
>
> So my question is this:
> How can I structure a query so that I can order products based on the
> number of people who would purchase it again?
>
> It'd be alot easier for me, and probably my server, if I just kept a
> running count of those in the actual product record, but I'm trying to
> keep it dynamic so that I can create custom reviewer sets elsewhere.
>
> Thanks in advance for any direction.
--
===============================================================================
Tomas Meinlschmidt, MS {MCT, MCP+I, MCSE, AER}, NetApp Filer/NetCache
www.meinlschmidt.com www.maxwellrender.cz www.lightgems.cz
===============================================================================
--~--~---------~--~----~------------~-------~--~----~
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 [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
