ihorzhuk / fb-rubybone Goto Github PK

[5873e8c4-3cc6-4a0c-8a11-20f46ddf7f6b] ActiveRecord::StatementInvalid (PG::GroupingError: ERROR: column "transactions.kind" must appear in the GROUP BY clause or be used in an aggregate function
2017-02-08T22:08:59.651179+00:00 app[web.1]: LINE 1: SELECT kind, categories.title, SUM(amount) as total FROM "tr...
2017-02-08T22:08:59.651180+00:00 app[web.1]: ^
2017-02-08T22:08:59.651180+00:00 app[web.1]: : SELECT kind, categories.title, SUM(amount) as total FROM "transactions" INNER JOIN "categories" ON "categories"."id" = "transactions"."category_id" WHERE "transactions"."user_id" = 1 AND (date >= '2017-01-31 00:00:00') AND (date <= '2017-02-27 23:59:59.999999') GROUP BY "transactions"."category_id"):

PR: #3