liquid_feedback_core
changeset 319:685d38986598
Bugfix in view "remaining_harmonic_suggestion_weight_summands"
author | jbe |
---|---|
date | Sat Feb 02 22:31:55 2013 +0100 (2013-02-02) |
parents | 89974afd890b |
children | 3a7f06a88ecb |
files | core.sql update/core-update.v2.1.0-v2.1.1.sql |
line diff
1.1 --- a/core.sql Sat Feb 02 22:26:18 2013 +0100 1.2 +++ b/core.sql Sat Feb 02 22:31:55 2013 +0100 1.3 @@ -3210,6 +3210,10 @@ 1.4 JOIN "opinion" 1.5 ON "remaining_harmonic_opinion_weight"."initiative_id" = "opinion"."initiative_id" 1.6 AND "remaining_harmonic_opinion_weight"."member_id" = "opinion"."member_id" 1.7 + AND ( 1.8 + ("opinion"."degree" > 0 AND "opinion"."fulfilled" = FALSE) OR 1.9 + ("opinion"."degree" < 0 AND "opinion"."fulfilled" = TRUE) 1.10 + ) 1.11 JOIN "suggestion" 1.12 ON "opinion"."suggestion_id" = "suggestion"."id" 1.13 AND "suggestion"."harmonic_weight" ISNULL
2.1 --- a/update/core-update.v2.1.0-v2.1.1.sql Sat Feb 02 22:26:18 2013 +0100 2.2 +++ b/update/core-update.v2.1.0-v2.1.1.sql Sat Feb 02 22:31:55 2013 +0100 2.3 @@ -162,6 +162,10 @@ 2.4 JOIN "opinion" 2.5 ON "remaining_harmonic_opinion_weight"."initiative_id" = "opinion"."initiative_id" 2.6 AND "remaining_harmonic_opinion_weight"."member_id" = "opinion"."member_id" 2.7 + AND ( 2.8 + ("opinion"."degree" > 0 AND "opinion"."fulfilled" = FALSE) OR 2.9 + ("opinion"."degree" < 0 AND "opinion"."fulfilled" = TRUE) 2.10 + ) 2.11 JOIN "suggestion" 2.12 ON "opinion"."suggestion_id" = "suggestion"."id" 2.13 AND "suggestion"."harmonic_weight" ISNULL