liquid_feedback_core
changeset 318:89974afd890b
Bugfix in view "remaining_harmonic_opinion_weight"
author | jbe |
---|---|
date | Sat Feb 02 22:26:18 2013 +0100 (2013-02-02) |
parents | 09e2805decd3 |
children | 685d38986598 |
files | core.sql update/core-update.v2.1.0-v2.1.1.sql |
line diff
1.1 --- a/core.sql Sat Feb 02 20:37:03 2013 +0100 1.2 +++ b/core.sql Sat Feb 02 22:26:18 2013 +0100 1.3 @@ -3188,6 +3188,9 @@ 1.4 ("opinion"."degree" > 0 AND "opinion"."fulfilled" = FALSE) OR 1.5 ("opinion"."degree" < 0 AND "opinion"."fulfilled" = TRUE) 1.6 ) 1.7 + JOIN "suggestion" 1.8 + ON "opinion"."suggestion_id" = "suggestion"."id" 1.9 + AND "suggestion"."harmonic_weight" ISNULL 1.10 GROUP BY 1.11 "initiative"."issue_id", 1.12 "opinion"."initiative_id",
2.1 --- a/update/core-update.v2.1.0-v2.1.1.sql Sat Feb 02 20:37:03 2013 +0100 2.2 +++ b/update/core-update.v2.1.0-v2.1.1.sql Sat Feb 02 22:26:18 2013 +0100 2.3 @@ -141,6 +141,9 @@ 2.4 ("opinion"."degree" > 0 AND "opinion"."fulfilled" = FALSE) OR 2.5 ("opinion"."degree" < 0 AND "opinion"."fulfilled" = TRUE) 2.6 ) 2.7 + JOIN "suggestion" 2.8 + ON "opinion"."suggestion_id" = "suggestion"."id" 2.9 + AND "suggestion"."harmonic_weight" ISNULL 2.10 GROUP BY 2.11 "initiative"."issue_id", 2.12 "opinion"."initiative_id",