diff options
| -rw-r--r-- | app/models/issue_query.rb | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/app/models/issue_query.rb b/app/models/issue_query.rb index 672785cc1..235bf2fbe 100644 --- a/app/models/issue_query.rb +++ b/app/models/issue_query.rb @@ -581,10 +581,10 @@ class IssueQuery < Query sw = operator == "!" ? 'NOT' : '' nl = operator == "!" ? "#{Issue.table_name}.assigned_to_id IS NULL OR" : '' subquery = - "SELECT DISTINCT #{Member.table_name}.user_id" + + "SELECT DISTINCT #{Member.table_name}.user_id, #{Member.table_name}.project_id" + " FROM #{Member.table_name}, #{MemberRole.table_name}" + - " WHERE #{Member.table_name}.project_id = #{Issue.table_name}.project_id AND #{Member.table_name}.id = #{MemberRole.table_name}.member_id AND #{role_cond}" - "(#{nl} #{Issue.table_name}.assigned_to_id #{sw} IN (#{subquery}))" + " WHERE #{Member.table_name}.id = #{MemberRole.table_name}.member_id AND #{role_cond}" + "(#{nl} (#{Issue.table_name}.assigned_to_id, #{Issue.table_name}.project_id) #{sw} IN (#{subquery}))" end end |