# HG changeset patch # User bsw # Date 1362858681 -3600 # Node ID 7d0592d4cf0f0fe32227f8b90a3884378cbc01c0 # Parent c7215c18168bbb0a5a66a17d769fbf1e7c662ce8 Added group_by clauses removed in changeset 5d2a337a33e4 again without "ranks_available" diff -r c7215c18168b -r 7d0592d4cf0f model/issue.lua --- a/model/issue.lua Sat Mar 09 20:48:01 2013 +0100 +++ b/model/issue.lua Sat Mar 09 20:51:21 2013 +0100 @@ -213,6 +213,25 @@ :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"') + :add_group_by('"issue"."accepted"') + :add_group_by('"issue"."half_frozen"') + :add_group_by('"issue"."fully_frozen"') + :add_group_by('"issue"."closed"') + :add_group_by('"issue"."status_quo_schulze_rank"') + :add_group_by('"issue"."cleaned"') + :add_group_by('"issue"."snapshot"') + :add_group_by('"issue"."latest_snapshot_event"') + :add_group_by('"issue"."population"') + :add_group_by('"issue"."voter_count"') + :add_group_by('"issue"."admission_time"') + :add_group_by('"issue"."discussion_time"') + :add_group_by('"issue"."verification_time"') + :add_group_by('"issue"."voting_time"') + --:set_distinct() end function Issue:modify_selector_for_state(initiatives_selector, state)