Ruby on Rails 3：如何按另一个表的属性对 ActiveRecords 进行排序？
我需要查询数据库表并获取按关联计数排序的行。有Rails（如Active Record Query）方法来做到这一点吗？
我的模型及其关联如下：
class User < ActiveRecord::Base
has_one :business
end
class Business < ActiveRecord::Base
has_many :postulations
end
class Postulation < ActiveRecord::Base
belongs_to :business
end
我需要根据其业务拥有的假设数量来排序用户数量。有没有一种干净的方法可以做到这一点，或者我只需使用 find_by_sql 进行查询？
谢谢。
I need to query a database table and get the rows ordered by a count of an association. Is there a Rails (like Active Record Query) way to do this?
My models and their associations are as follows:
class User < ActiveRecord::Base
has_one :business
end
class Business < ActiveRecord::Base
has_many :postulations
end
class Postulation < ActiveRecord::Base
belongs_to :business
end
I need to get a number of Users ordered by the amount of Postulations that their Business has. Is there a clean way to do this or do I just have to query with find_by_sql?
Thank you.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
这可能会起作用
This will probably work