ruby-on-rails - User Helper Method - 抓取ID与当前用户ID不匹配的用户

Question

尝试编写具有 3 个基本条件的辅助方法。添加第三个，它试图将当前用户从结果中移除，这会导致错误。

  def male_soccer_players
    return User.where(:gender => "male", :soccer => true, :id != current_user.id)
  end

错误是

app/controllers/application_controller.rb:12: syntax error, unexpected ')', expecting => 

Answer 1

中的问题:id != current_user.idRails .where 只传递哈希尝试

def male_soccer_players
  User.where(:gender => "male", :soccer => true).where('id != ?', current_user.id)
end

或

def male_soccer_players
  User.where('gender = ? and soccer = ? and id != ?', "male", true, current_user.id)
end