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

Impressum / About Us