liquid_feedback_core
diff update/core-update.v3.1.0-v3.2.0.sql @ 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 |
line diff
1.1 --- a/update/core-update.v3.1.0-v3.2.0.sql Sun Apr 03 20:54:45 2016 +0200 1.2 +++ b/update/core-update.v3.1.0-v3.2.0.sql Sun Apr 03 20:57:44 2016 +0200 1.3 @@ -285,7 +285,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 (