sql - Rails : Two 'where' queries - each works individually, 但不在一起

Question

我想写这样的东西:

@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")

但是我需要对 meeting_time 做一个大于查询，所以我认为我需要将它写成一个字符串？

但是两个 sql 查询一起产生错误:ambiguous column name: status: SELECT

我觉得我是如此接近......我在这里错过了什么？

Answer 1

这是在不清楚列来自哪个表时出现的消息。这应该有效:

...rest_of_statement.where('meetings.status' => 'Active')