Have you tried adding a 'where' condition to your query? E.G., relation = Project.includes(:bids, :user).references(:users, :bids).where(bids > 0).sort.reverse
On Thu, Jun 6, 2019 at 4:06 AM Arup Rakshit <tuka...@gmail.com> wrote: > I have a Project and Bid model. > > Project has_many :bids > Bid belongs_to project > > I have now > relation = Project.includes(:bids, :user).references(:users, :bids) > > What I now want is : select projects by ordering them with their bids > count. How can I write this query? > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to rubyonrails-talk+unsubscr...@googlegroups.com. > To post to this group, send email to rubyonrails-talk@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rubyonrails-talk/CAKxHnE1VBowD-dGZTFBgFBDVrznRj29HVBYprSphyJzxtGdD0w%40mail.gmail.com > <https://groups.google.com/d/msgid/rubyonrails-talk/CAKxHnE1VBowD-dGZTFBgFBDVrznRj29HVBYprSphyJzxtGdD0w%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscr...@googlegroups.com. To post to this group, send email to rubyonrails-talk@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CAKPjS73yPSgEnp0sq%3DJZsYNCMGd6GPqtGV6qbv30uWhi9rLFGA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.