Rails4 order method does not work in PostgreSQL

Question

i created a method like below

def sort_by_footprints
  joins(:footprints).group(:article_id).order('SUM(articles.id) DESC')
end

but this doesn't work when i use postgresql and it says ActionView::Template::Error (PG::GroupingError: ERROR: column "articles.id" must appear in the GROUP BY clause or be used in an aggregate function how can i fix it?

score 2 · Accepted Answer · answered Mar 14 '15 at 18:55

2

Try this:

joins(:footprints).group(:article_id).select('SUM(articles.id) as total_articles').order('total_articles DESC')

answered Mar 14 '15 at 18:55

Nathan

7,627
11
46
80

This is just what i want! Thnx!! ;) – Fumiya Apr 09 '15 at 07:10

Rails4 order method does not work in PostgreSQL

1 Answers1