ruby-on-rails - 通过关联进行 Rails 排序

Question

我正在尝试从 Member.board.order 的模型 Members 升序排序

在我的 Controller 上，institutional_controller.rb 我有:

@display = Member.includes(:board).where('is_board = ?', true).order('member.board.order ASC').references(:board)

# board.rb and member.rb

class Board < ActiveRecord::Base
  belongs_to :member
end

class Member < ActiveRecord::Base
  has_one :board
end


# index.html.erb

<% @display.each do |member|  %> [...]

我得到的错误是:

PG::UndefinedTable: ERROR:  missing FROM-clause entry for table "board"
LINE 1: ...= "members"."id" WHERE (is_board = 't')  ORDER BY member.board [...]

谢谢。任何帮助将不胜感激。

Answer 1

现在它是这样工作的:

Member.includes(:board).where('is_board = ?', true).order('boards.order ASC').references(:board)