# HG changeset patch
# User bsw
# Date 1535283494 -7200
# Node ID 3dbfac432576845ae452e0cadb44c79da850b039
# Parent  b42bea44f26cece4b63d25afa064b68f1e329d5f
Fixed endless loop while sending notification when not issue is created yet

diff -r b42bea44f26c -r 3dbfac432576 model/initiative_for_notification.lua
--- a/model/initiative_for_notification.lua	Mon Aug 20 18:43:17 2018 +0200
+++ b/model/initiative_for_notification.lua	Sun Aug 26 13:38:14 2018 +0200
@@ -21,8 +21,8 @@
   local selector = db:new_selector()
     :add_field("*")
     :from({ "get_initiatives_for_notification(?)", member_id }, "initiative_for_notification")
-    :join("initiative", nil, "initiative.id = initiative_for_notification.initiative_id")
-    :join("issue", nil, "issue.id = initiative.issue_id")
+    :left_join("initiative", nil, "initiative.id = initiative_for_notification.initiative_id")
+    :left_join("issue", nil, "issue.id = initiative.issue_id")
     :join("member", nil, "member.id = initiative_for_notification.recipient_id")
     :add_order_by("md5(initiative_for_notification.recipient_id || '-' || member.notification_counter || '-' || issue.area_id)")
     :add_order_by("md5(initiative_for_notification.recipient_id || '-' || member.notification_counter || '-' || issue.id)")