liquid_feedback_core

changeset 487:14bca0b56925

Ignore suggestions with opinion
author jbe
date Sun Apr 03 16:26:38 2016 +0200 (2016-04-03)
parents 9aa403a05261
children 056ad11bbe66
files core.sql
line diff
     1.1 --- a/core.sql	Sat Apr 02 22:08:39 2016 +0200
     1.2 +++ b/core.sql	Sun Apr 03 16:26:38 2016 +0200
     1.3 @@ -2425,7 +2425,11 @@
     1.4        AND "draft"."id" > "supporter"."draft_id"
     1.5      ) OR EXISTS (
     1.6        SELECT NULL FROM "suggestion"
     1.7 +      LEFT JOIN "opinion" ON
     1.8 +        "opinion"."member_id" = "supporter"."member_id" AND
     1.9 +        "opinion"."suggestion_id" = "suggestion"."id"
    1.10        WHERE "suggestion"."initiative_id" = "initiative"."id"
    1.11 +      AND "opinion"."member_id" ISNULL
    1.12        AND COALESCE(
    1.13          "suggestion"."id" > "sent"."last_suggestion_id",
    1.14          TRUE

Impressum / About Us