我想写类似以下的内容:
@meeting_requests = Meeting.where('meeting_time >= ? AND requestee_id IS ?
AND status = ?', Date.today, nil, "Active")
.joins(:requestor)
.where('birthyear >= ? AND birthyear <= ?',
current_user.birthyear - 10,
current_user.birthyear + 10 )
这个有效:
@meeting_requests = Meeting.where('meeting_time >= ? AND requestee_id IS ?
AND status = ?', Date.today, nil, "Active")
这个是有效的:
@meeting_requests = Meeting.joins(:requestor)
.where('birthyear >= ? AND birthyear <= ?',
current_user.birthyear - 10,
current_user.birthyear + 10 )
而像这样的东西是可行的:
Meeting.joins(:requestor).where('birthyear > ?', 1900).where(status: "Active")
但是我需要对会议时间进行大于查询,因此我需要将其写成字符串形式,是这样吗?
但是,两个SQL查询一起产生错误:ambiguous column name: status: SELECT
我感觉我离成功很近了...这里缺少什么?