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",

Impressum / About Us