liquid_feedback_frontend
changeset 302:12a578e75f3e
Added missing join on clause for delegations selection
author | bsw |
---|---|
date | Sun Feb 26 14:20:00 2012 +0100 (2012-02-26) |
parents | 22e4e26717ac |
children | 805bb2f70b0a |
files | app/main/unit/show.lua |
line diff
1.1 --- a/app/main/unit/show.lua Sun Feb 26 14:15:27 2012 +0100 1.2 +++ b/app/main/unit/show.lua Sun Feb 26 14:20:00 2012 +0100 1.3 @@ -39,9 +39,9 @@ 1.4 1.5 local delegations_selector = Delegation:new_selector() 1.6 :join("member", "truster", "truster.id = delegation.truster_id AND truster.active") 1.7 - :join("privilege", "truster_privilege", "truster_privilege.member_id = truster.id AND truster_privilege.voting_right") 1.8 + :join("privilege", "truster_privilege", "truster_privilege.member_id = truster.id AND truster_privilege.unit_id = delegation.unit_id AND truster_privilege.voting_right") 1.9 :join("member", "trustee", "trustee.id = delegation.trustee_id AND truster.active") 1.10 - :join("privilege", "trustee_privilege", "trustee_privilege.member_id = trustee.id AND trustee_privilege.voting_right") 1.11 + :join("privilege", "trustee_privilege", "trustee_privilege.member_id = trustee.id AND trustee_privilege.unit_id = delegation.unit_id AND trustee_privilege.voting_right") 1.12 :add_where{ "delegation.unit_id = ?", unit.id } 1.13 1.14 local issues_selector = Issue:new_selector()