# HG changeset patch
# User bsw
# Date 1340572104 -7200
# Node ID 42afe0765f867d0e21a433c88bbf060c6b72f7b0
# Parent  c4144daf690625dab089bc26d3a25a8cfcc12af7
Show broken area and unit delegations too

diff -r c4144daf6906 -r 42afe0765f86 model/delegation.lua
--- a/model/delegation.lua	Sun Jun 24 23:01:00 2012 +0200
+++ b/model/delegation.lua	Sun Jun 24 23:08:24 2012 +0200
@@ -64,7 +64,8 @@
 
 function Delegation:selector_for_broken(member_id)
   return Delegation:new_selector()
-    :join("issue", nil, "issue.id = delegation.issue_id AND issue.closed ISNULL")
+    :left_join("issue", nil, "issue.id = delegation.issue_id")
+    :add_where("issue.id ISNULL OR issue.closed ISNULL")
     :join("member", nil, "delegation.trustee_id = member.id")
     :add_where{"delegation.truster_id = ?", member_id}
     :add_where{"member.active = 'f' OR (member.last_activity IS NULL OR age(member.last_activity) > ?::interval)", config.delegation_warning_time }