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"')

Impressum / About Us