liquid_feedback_core
changeset 503:986d8f3a6895
Exclude revoked initiatives from updated/featured/leading initiatives in notification system
author | jbe |
---|---|
date | Tue Apr 05 00:19:33 2016 +0200 (2016-04-05) |
parents | f39c673420cb |
children | d07e6a046d41 |
files | core.sql update/core-update.v3.1.0-v3.2.0.sql |
line diff
1.1 --- a/core.sql Mon Apr 04 23:55:22 2016 +0200 1.2 +++ b/core.sql Tue Apr 05 00:19:33 2016 +0200 1.3 @@ -2381,6 +2381,7 @@ 1.4 "ignored_initiative"."member_id" = "supporter"."member_id" AND 1.5 "ignored_initiative"."initiative_id" = "supporter"."initiative_id" 1.6 WHERE "issue"."state" IN ('admission', 'discussion') 1.7 + AND "initiative"."revoked" ISNULL 1.8 AND "ignored_initiative"."member_id" ISNULL 1.9 AND ( 1.10 EXISTS ( 1.11 @@ -2466,6 +2467,7 @@ 1.12 WHERE "supporter"."member_id" = "member_id_v" 1.13 AND "issue"."area_id" = "area_id_p" 1.14 AND "issue"."state" IN ('admission', 'discussion', 'verification') 1.15 + AND "initiative"."revoked" ISNULL 1.16 AND "self_support"."member_id" ISNULL 1.17 AND NOT "initiative_id_ary" @> ARRAY["initiative"."id"] 1.18 AND ( 1.19 @@ -2534,6 +2536,7 @@ 1.20 "uf_initiative_full"."id" = "uf_initiative"."initiative_id" 1.21 JOIN "initiative" ON 1.22 "initiative"."issue_id" = "uf_initiative_full"."issue_id" 1.23 + WHERE "initiative"."revoked" ISNULL 1.24 ORDER BY 1.25 "uf_initiative"."recipient_id", 1.26 "initiative"."issue_id",
2.1 --- a/update/core-update.v3.1.0-v3.2.0.sql Mon Apr 04 23:55:22 2016 +0200 2.2 +++ b/update/core-update.v3.1.0-v3.2.0.sql Tue Apr 05 00:19:33 2016 +0200 2.3 @@ -100,6 +100,7 @@ 2.4 "ignored_initiative"."member_id" = "supporter"."member_id" AND 2.5 "ignored_initiative"."initiative_id" = "supporter"."initiative_id" 2.6 WHERE "issue"."state" IN ('admission', 'discussion') 2.7 + AND "initiative"."revoked" ISNULL 2.8 AND "ignored_initiative"."member_id" ISNULL 2.9 AND ( 2.10 EXISTS ( 2.11 @@ -185,6 +186,7 @@ 2.12 WHERE "supporter"."member_id" = "member_id_v" 2.13 AND "issue"."area_id" = "area_id_p" 2.14 AND "issue"."state" IN ('admission', 'discussion', 'verification') 2.15 + AND "initiative"."revoked" ISNULL 2.16 AND "self_support"."member_id" ISNULL 2.17 AND NOT "initiative_id_ary" @> ARRAY["initiative"."id"] 2.18 AND ( 2.19 @@ -253,6 +255,7 @@ 2.20 "uf_initiative_full"."id" = "uf_initiative"."initiative_id" 2.21 JOIN "initiative" ON 2.22 "initiative"."issue_id" = "uf_initiative_full"."issue_id" 2.23 + WHERE "initiative"."revoked" ISNULL 2.24 ORDER BY 2.25 "uf_initiative"."recipient_id", 2.26 "initiative"."issue_id",