liquid_feedback_frontend
changeset 481:ec2ff3e0b0e6
Add missing group by clauses for search selectors
author | bsw |
---|---|
date | Thu Mar 15 13:20:18 2012 +0100 (2012-03-15) |
parents | af496baa9bda |
children | 3bc96debbd05 |
files | model/initiative.lua model/issue.lua |
line diff
1.1 --- a/model/initiative.lua Thu Mar 15 13:12:51 2012 +0100 1.2 +++ b/model/initiative.lua Thu Mar 15 13:20:18 2012 +0100 1.3 @@ -120,6 +120,7 @@ 1.4 :add_group_by('"initiative"."discussion_url"') 1.5 :add_group_by('"initiative"."created"') 1.6 :add_group_by('"initiative"."revoked"') 1.7 + :add_group_by('"initiative"."revoked_by_member_id"') 1.8 :add_group_by('"initiative"."admitted"') 1.9 :add_group_by('"initiative"."supporter_count"') 1.10 :add_group_by('"initiative"."informed_supporter_count"')
2.1 --- a/model/issue.lua Thu Mar 15 13:12:51 2012 +0100 2.2 +++ b/model/issue.lua Thu Mar 15 13:20:18 2012 +0100 2.3 @@ -128,6 +128,7 @@ 2.4 :join('"draft"', nil, '"draft"."initiative_id" = "initiative"."id"') 2.5 :add_where{ '"initiative"."text_search_data" @@ "text_search_query"(?) OR "draft"."text_search_data" @@ "text_search_query"(?)', search_string, search_string } 2.6 :add_group_by('"issue"."id"') 2.7 + :add_group_by('"issue"."state"') 2.8 :add_group_by('"issue"."area_id"') 2.9 :add_group_by('"issue"."policy_id"') 2.10 :add_group_by('"issue"."created"')