liquid_feedback_frontend
changeset 976:7d0592d4cf0f
Added group_by clauses removed in changeset 5d2a337a33e4 again without "ranks_available"
author | bsw |
---|---|
date | Sat Mar 09 20:51:21 2013 +0100 (2013-03-09) |
parents | c7215c18168b |
children | 9e5eb584fd43 |
files | model/issue.lua |
line diff
1.1 --- a/model/issue.lua Sat Mar 09 20:48:01 2013 +0100 1.2 +++ b/model/issue.lua Sat Mar 09 20:51:21 2013 +0100 1.3 @@ -213,6 +213,25 @@ 1.4 :join('"draft"', nil, '"draft"."initiative_id" = "initiative"."id"') 1.5 :add_where{ '"initiative"."text_search_data" @@ "text_search_query"(?) OR "draft"."text_search_data" @@ "text_search_query"(?)', search_string, search_string } 1.6 :add_group_by('"issue"."id"') 1.7 + :add_group_by('"issue"."state"') 1.8 + :add_group_by('"issue"."area_id"') 1.9 + :add_group_by('"issue"."policy_id"') 1.10 + :add_group_by('"issue"."created"') 1.11 + :add_group_by('"issue"."accepted"') 1.12 + :add_group_by('"issue"."half_frozen"') 1.13 + :add_group_by('"issue"."fully_frozen"') 1.14 + :add_group_by('"issue"."closed"') 1.15 + :add_group_by('"issue"."status_quo_schulze_rank"') 1.16 + :add_group_by('"issue"."cleaned"') 1.17 + :add_group_by('"issue"."snapshot"') 1.18 + :add_group_by('"issue"."latest_snapshot_event"') 1.19 + :add_group_by('"issue"."population"') 1.20 + :add_group_by('"issue"."voter_count"') 1.21 + :add_group_by('"issue"."admission_time"') 1.22 + :add_group_by('"issue"."discussion_time"') 1.23 + :add_group_by('"issue"."verification_time"') 1.24 + :add_group_by('"issue"."voting_time"') 1.25 + --:set_distinct() 1.26 end 1.27 1.28 function Issue:modify_selector_for_state(initiatives_selector, state)