Sort data in ruby on rails

Question

Association is like

class User < ActiveRecord::Base

has_many :products
has_many :ratings

I want to sort products according to user ratings. Let suppose I want to sort all those product whose ratings is greater than 4. I cant find any way to do that.

I do something like

User.joins(:ratings).where("ratings.rate > ?", 4).includes(:ratings)

From that I get all user whose ratings is greater than 4 but how join with product and sort them?

Hey Usman, you should just accept one as a solution, to let other people know that you found your solution. — Abhinay
– Abhinay, Commented Oct 14, 2015 at 16:40

Community · Accepted Answer · 2017-05-23 10:30:11Z

3

User.joins(:ratings).where("ratings.rate > ?", 4).order('ratings DESC')

I am not sure what includes(:ratings) doing at the last. Should just use something like this and it should probably work:

User.includes(:ratings).where("ratings.rate > ?", 4).order('ratings DESC')

Reference: issue in order clause and limit in active record

edited May 23, 2017 at 10:30

CommunityBot

11 silver badge

answered Oct 14, 2015 at 12:17

Abhinay

1,8164 gold badges29 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

nsave · Accepted Answer · 2015-10-14 12:24:55Z

1

User.joins(:ratings).where("ratings.rate > ?", 4).order('ratings.rate')

And if you want to find associated products then this should work:

Product.joins(user: :ratings).where("ratings.rate > ?", 4).order('ratings.rate')

edited Oct 14, 2015 at 12:24

answered Oct 14, 2015 at 12:15

nsave

9849 silver badges27 bronze badges

Collectives™ on Stack Overflow

Sort data in ruby on rails

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related