# HG changeset patch
# User bsw
# Date 1331814018 -3600
# Node ID ec2ff3e0b0e6f87c875ea7f2352ea85ac42c316b
# Parent  af496baa9bda91c0066a618f27eb15a0563a083c
Add missing group by clauses for search selectors

diff -r af496baa9bda -r ec2ff3e0b0e6 model/initiative.lua
--- a/model/initiative.lua	Thu Mar 15 13:12:51 2012 +0100
+++ b/model/initiative.lua	Thu Mar 15 13:20:18 2012 +0100
@@ -120,6 +120,7 @@
     :add_group_by('"initiative"."discussion_url"')
     :add_group_by('"initiative"."created"')
     :add_group_by('"initiative"."revoked"')
+    :add_group_by('"initiative"."revoked_by_member_id"')
     :add_group_by('"initiative"."admitted"')
     :add_group_by('"initiative"."supporter_count"')
     :add_group_by('"initiative"."informed_supporter_count"')
diff -r af496baa9bda -r ec2ff3e0b0e6 model/issue.lua
--- a/model/issue.lua	Thu Mar 15 13:12:51 2012 +0100
+++ b/model/issue.lua	Thu Mar 15 13:20:18 2012 +0100
@@ -128,6 +128,7 @@
     :join('"draft"', nil, '"draft"."initiative_id" = "initiative"."id"')
     :add_where{ '"initiative"."text_search_data" @@ "text_search_query"(?) OR "draft"."text_search_data" @@ "text_search_query"(?)', search_string, search_string }
     :add_group_by('"issue"."id"')
+    :add_group_by('"issue"."state"')
     :add_group_by('"issue"."area_id"')
     :add_group_by('"issue"."policy_id"')
     :add_group_by('"issue"."created"')