ruby - 导轨 4 : column reference "updated_at" is ambiguous with Postgres

Question

我正在尝试使用“updated_at”字段的日期时间范围查询数据库。前端在 JSON 数组中发送查询:

["2015-09-01 00:00:00","2015-10-02 23:00:00"]

在 Rails Controller 中，我使用以下方法将两个字符串解析为 DateTime:

start_date = DateTime.parse(params[:date_range_arr][0])
end_date = DateTime.parse(params[:date_range_arr][1])

#...
@events = @events.where('updated_at BETWEEN ? AND ?,
       start_date, end_date
)

查询显示:

WHERE (updated_at BETWEEN '2015-09-01 00:00:00.000000' AND '2015-10-02 23:00:00.000000')

错误是:

ActionView::Template::Error (PG::AmbiguousColumn: ERROR:  column reference "updated_at" is ambiguous
LINE 1: ...texts"."id" = "events"."context_id" WHERE (updated_at...

Answer 1

您是否有任何机会在事件模型或上面的代码中加入或包含原始问题中包含的内容的默认范围？

无论哪种方式，您只需要按如下方式更加具体地查询:

#...
@events = @events.where('events.updated_at BETWEEN ? AND ?,
   start_date, end_date
)