liquid_feedback_core

diff core.sql @ 317:09e2805decd3
Count non-fulfilled suggestions with positive opinion and fulfilled suggestions with negative opinion for "harmonic_weight" of suggestions
author: jbe
date: Sat Feb 02 20:37:03 2013 +0100 (2013-02-02)
parents: 727926e290e7
children: 89974afd890b
     1.1 --- a/core.sql	Sat Feb 02 20:21:16 2013 +0100
     1.2 +++ b/core.sql	Sat Feb 02 20:37:03 2013 +0100
     1.3 @@ -3184,7 +3184,10 @@
     1.4    JOIN "opinion"
     1.5      ON "direct_interest_snapshot"."member_id" = "opinion"."member_id"
     1.6      AND "initiative"."id" = "opinion"."initiative_id"
     1.7 -    AND "opinion"."degree" > 0
     1.8 +    AND (
     1.9 +      ("opinion"."degree" > 0 AND "opinion"."fulfilled" = FALSE) OR
    1.10 +      ("opinion"."degree" < 0 AND "opinion"."fulfilled" = TRUE)
    1.11 +    )
    1.12    GROUP BY
    1.13      "initiative"."issue_id",
    1.14      "opinion"."initiative_id",