liquid_feedback_core
changeset 498:10b90162e982
Corrected comparison operator in view "newsletter_to_send"
author | jbe |
---|---|
date | Sun Apr 03 20:57:44 2016 +0200 (2016-04-03) |
parents | 91e3d31c1de2 |
children | bc4b590a8eec |
files | core.sql update/core-update.v3.1.0-v3.2.0.sql |
line diff
1.1 --- a/core.sql Sun Apr 03 20:54:45 2016 +0200 1.2 +++ b/core.sql Sun Apr 03 20:57:44 2016 +0200 1.3 @@ -2633,7 +2633,7 @@ 1.4 LEFT JOIN "subscription" ON 1.5 "subscription"."member_id" = "member"."id" AND 1.6 "subscription"."unit_id" = "newsletter"."unit_id" 1.7 - WHERE "newsletter"."published" >= now() 1.8 + WHERE "newsletter"."published" <= now() 1.9 AND "newsletter"."sent" ISNULL 1.10 AND "member"."locked" = FALSE 1.11 AND (
2.1 --- a/update/core-update.v3.1.0-v3.2.0.sql Sun Apr 03 20:54:45 2016 +0200 2.2 +++ b/update/core-update.v3.1.0-v3.2.0.sql Sun Apr 03 20:57:44 2016 +0200 2.3 @@ -285,7 +285,7 @@ 2.4 LEFT JOIN "subscription" ON 2.5 "subscription"."member_id" = "member"."id" AND 2.6 "subscription"."unit_id" = "newsletter"."unit_id" 2.7 - WHERE "newsletter"."published" >= now() 2.8 + WHERE "newsletter"."published" <= now() 2.9 AND "newsletter"."sent" ISNULL 2.10 AND "member"."locked" = FALSE 2.11 AND (