# HG changeset patch
# User bsw
# Date 1296931655 -3600
# Node ID bfd8d88f72fcb511bc20126805a4a92d10c7ea7f
# Parent  c57dcff4162d666e9082eb35ddc0158997f89ec2
Display broken delegations only for open issues.

diff -r c57dcff4162d -r bfd8d88f72fc app/main/member/show_tab.lua
--- a/app/main/member/show_tab.lua	Sat Feb 05 18:45:04 2011 +0100
+++ b/app/main/member/show_tab.lua	Sat Feb 05 19:47:35 2011 +0100
@@ -44,6 +44,7 @@
   end
 
   local broken_delegations = Delegation:new_selector()
+    :join("issue", nil, "issue.id = delegation.issue_id AND 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_login_public IS NULL OR age(member.last_login) > ?::interval)", config.delegation_warning_time }