我有一个Rails 3.2.14应用程序,我在其中尝试使用chartkick
和groupdate
gem生成一些图表。我已经安装了这两个gem,并且正在尝试从Call
模型上的控制台进行一些测试查询。
Call.group_by_day(:created_at)
我引发异常并得到以下错误:
Call Load (8.8ms) SELECT "calls".* FROM "calls" WHERE (created_at IS NOT NULL) GROUP BY (DATE_TRUNC('week', (created_at::timestamptz - INTERVAL '6 day' - INTERVAL '0' hour) AT TIME ZONE 'America/Chicago') + INTERVAL '6 day' + INTERVAL '0' hour) AT TIME ZONE 'America/Chicago'
ActiveRecord::StatementInvalid: PG::Error: ERROR: column "calls.id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT "calls".* FROM "calls" WHERE (created_at IS NOT NULL...
^
: SELECT "calls".* FROM "calls" WHERE (created_at IS NOT NULL) GROUP BY (DATE_TRUNC('week', (created_at::timestamptz - INTERVAL '6 day' - INTERVAL '0' hour) AT TIME ZONE 'America/Chicago') + INTERVAL '6 day' + INTERVAL '0' hour) AT TIME ZONE 'America/Chicago
我应该做些什么来使这项工作吗?我需要创建某种范围的工具才能完成这项工作吗?我是宝石的新手,因此将不胜感激。
显然我没有正确地称呼它。
我需要打电话Call.group_by_day(:created_at).count
进行这项工作。
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句