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.1 -r1.5.2.2
--- openacs-4/packages/bug-tracker/tcl/bug-procs-postgresql.xql	29 Apr 2004 10:36:07 -0000	1.5.2.1
+++ openacs-4/packages/bug-tracker/tcl/bug-procs-postgresql.xql	10 Nov 2004 18:43:52 -0000	1.5.2.2
@@ -185,7 +185,6 @@
          $more_columns
     from $from_bug_clause,
          acs_users_all submitter,
-         acs_users_all assignee,
          workflow_cases cas,
          workflow_case_fsm cfsm,
          workflow_fsm_states st 
@@ -206,15 +205,15 @@
           aa.action_id,
           aa.case_id,
           wa.pretty_name as action_pretty_name,
-          assignee.first_names as assignee_first_names,
-          assignee.last_name as assignee_last_name
+          p.first_names as assignee_first_names,
+          p.last_name as assignee_last_name
      from workflow_case_assigned_actions aa,
           workflow_case_role_user_map cru,
           workflow_actions wa,
-          acs_users_all assignee
+	  persons p
     where aa.case_id = cru.case_id
       and aa.role_id = cru.role_id
-      and cru.user_id = assignee.user_id
+      and cru.user_id = p.person_id
       and wa.action_id = aa.action_id
   ) assign_info
 on (q.case_id = assign_info.case_id)