Index: openacs-4/packages/bug-tracker/tcl/bug-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/tcl/bug-procs-oracle.xql,v diff -u -r1.4.2.6 -r1.4.2.7 --- openacs-4/packages/bug-tracker/tcl/bug-procs-oracle.xql 21 Jan 2005 23:35:11 -0000 1.4.2.6 +++ openacs-4/packages/bug-tracker/tcl/bug-procs-oracle.xql 23 Jan 2005 00:12:54 -0000 1.4.2.7 @@ -285,12 +285,12 @@ exists (select 1 from workflow_case_assigned_actions aa, - workflow_case_role_user_map crum + workflow_case_role_party_map wcrpm where aa.case_id = cas.case_id and aa.action_id = $action_id - and crum.case_id (+) = aa.case_id - and crum.role_id (+) = aa.role_id - and crum.user_id is null + and wcrpm.case_id (+) = aa.case_id + and wcrpm.role_id (+) = aa.role_id + and wcrpm.party_id is null ) Index: openacs-4/packages/bug-tracker/tcl/bug-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/tcl/bug-procs-postgresql.xql,v diff -u -r1.5.2.5 -r1.5.2.6 --- openacs-4/packages/bug-tracker/tcl/bug-procs-postgresql.xql 21 Jan 2005 23:35:11 -0000 1.5.2.5 +++ openacs-4/packages/bug-tracker/tcl/bug-procs-postgresql.xql 23 Jan 2005 00:12:54 -0000 1.5.2.6 @@ -273,11 +273,12 @@ exists (select 1 - from workflow_case_assigned_actions aa left outer join - workflow_case_role_user_map crum on (crum.case_id = aa.case_id and crum.role_id = aa.role_id) - where aa.case_id = cas.case_id - and aa.action_id = $action_id - and crum.user_id is null + from workflow_case_assigned_actions aa left outer join + workflow_case_role_party_map wcrpm + on (wcrpm.case_id = aa.case_id and wcrpm.role_id = aa.role_id) + where aa.case_id = cas.case_id + and aa.action_id = $action_id + and wcrpm.party_id is null ) Index: openacs-4/packages/bug-tracker/tcl/bug-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/tcl/bug-procs.xql,v diff -u -r1.4.4.1 -r1.4.4.2 --- openacs-4/packages/bug-tracker/tcl/bug-procs.xql 20 Jan 2005 02:11:22 -0000 1.4.4.1 +++ openacs-4/packages/bug-tracker/tcl/bug-procs.xql 23 Jan 2005 00:12:54 -0000 1.4.4.2 @@ -131,12 +131,12 @@ exists (select 1 from workflow_case_assigned_actions aa, - workflow_case_role_user_map crum + workflow_case_role_party_map wcrpm where aa.case_id = cas.case_id and aa.action_id = $action_id - and crum.case_id = aa.case_id - and crum.role_id = aa.role_id - and crum.user_id = :f_action_$action_id + and wcrpm.case_id = aa.case_id + and wcrpm.role_id = aa.role_id + and wcrpm.party_id = :f_action_$action_id )