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