liquid_feedback_core

diff core.sql @ 521:65bd17395c28
Exclude locked members as recipients in view "scheduled_notification_to_send"
author: jbe
date: Wed May 04 21:47:29 2016 +0200 (2016-05-04)
parents: 053190248598
children: 2f1c06608def
     1.1 --- a/core.sql	Wed May 04 21:44:18 2016 +0200
     1.2 +++ b/core.sql	Wed May 04 21:47:29 2016 +0200
     1.3 @@ -2710,7 +2710,8 @@
     1.4          "notification_dow",
     1.5          "notification_hour"
     1.6        FROM "member"
     1.7 -      WHERE "disable_notifications" = FALSE
     1.8 +      WHERE "locked" = FALSE
     1.9 +      AND "disable_notifications" = FALSE
    1.10        AND "notification_hour" NOTNULL
    1.11      ) AS "subquery1"
    1.12    ) AS "subquery2"