liquid_feedback_core
diff update/core-update.v2.1.0-v2.1.1.sql @ 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 |
line diff
1.1 --- a/update/core-update.v2.1.0-v2.1.1.sql Sat Feb 02 22:26:18 2013 +0100 1.2 +++ b/update/core-update.v2.1.0-v2.1.1.sql Sat Feb 02 22:31:55 2013 +0100 1.3 @@ -162,6 +162,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