liquid_feedback_frontend
changeset 1413:3dbfac432576
Fixed endless loop while sending notification when not issue is created yet
author | bsw |
---|---|
date | Sun Aug 26 13:38:14 2018 +0200 (2018-08-26) |
parents | b42bea44f26c |
children | cd497eb8fd73 |
files | model/initiative_for_notification.lua |
line diff
1.1 --- a/model/initiative_for_notification.lua Mon Aug 20 18:43:17 2018 +0200 1.2 +++ b/model/initiative_for_notification.lua Sun Aug 26 13:38:14 2018 +0200 1.3 @@ -21,8 +21,8 @@ 1.4 local selector = db:new_selector() 1.5 :add_field("*") 1.6 :from({ "get_initiatives_for_notification(?)", member_id }, "initiative_for_notification") 1.7 - :join("initiative", nil, "initiative.id = initiative_for_notification.initiative_id") 1.8 - :join("issue", nil, "issue.id = initiative.issue_id") 1.9 + :left_join("initiative", nil, "initiative.id = initiative_for_notification.initiative_id") 1.10 + :left_join("issue", nil, "issue.id = initiative.issue_id") 1.11 :join("member", nil, "member.id = initiative_for_notification.recipient_id") 1.12 :add_order_by("md5(initiative_for_notification.recipient_id || '-' || member.notification_counter || '-' || issue.area_id)") 1.13 :add_order_by("md5(initiative_for_notification.recipient_id || '-' || member.notification_counter || '-' || issue.id)")