Ruby China

新手问题 如何显示关联查询的全部内容

SunA0 · September 27, 2019 · Last by hzy_zzz replied at October 25, 2019 · 2654 hits

举例来说 一个机构有好多项目 通过写 find 方法找到机构符合条件的项目 result=Agency.find :all, :joins=>' INNER join projects on projects.agency_id=agencies.id', :conditions=>'projects.score>60' 这样 result 存的是 agencies 表的所有字段 可 projects 符合条件的内容又该如何显示

coderliu #2 September 28, 2019

Agency.includes(:project).where("project.score > 60")

1 likes
hzy_zzz #3 October 25, 2019

Agency.joins(:project).where("project.score > 60").preload(:project)

1 likes
SunA0 closed this topic. 26 Apr 10:53
You need to Sign in before reply, if you don't have an account, please Sign up first.