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.2 -r1.3
--- openacs-4/packages/bug-tracker/tcl/bug-procs-oracle.xql	28 Sep 2003 01:28:18 -0000	1.2
+++ openacs-4/packages/bug-tracker/tcl/bug-procs-oracle.xql	3 Oct 2003 16:54:36 -0000	1.3
@@ -199,5 +199,19 @@
   </querytext>
 </fullquery>
 
+  <partialquery name="bug_tracker::bug::get_list.filter_assignee_null_where_clause">
+      <querytext>
+          exists (select 1
+                  from   workflow_case_assigned_actions aa,
+                         workflow_case_role_user_map crum
+                  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
+                 )
+      </querytext>
+  </partialquery>
 
+
 </queryset>
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.3 -r1.4
--- openacs-4/packages/bug-tracker/tcl/bug-procs-postgresql.xql	28 Sep 2003 01:28:18 -0000	1.3
+++ openacs-4/packages/bug-tracker/tcl/bug-procs-postgresql.xql	3 Oct 2003 16:54:37 -0000	1.4
@@ -186,6 +186,17 @@
 </fullquery>
 
 
+  <partialquery name="bug_tracker::bug::get_list.filter_assignee_null_where_clause">
+      <querytext>
+          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
+                 )
+      </querytext>
+  </partialquery>
 
  
 </queryset>
Index: openacs-4/packages/bug-tracker/tcl/bug-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/tcl/bug-procs.tcl,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/bug-tracker/tcl/bug-procs.tcl	3 Oct 2003 16:41:39 -0000	1.6
+++ openacs-4/packages/bug-tracker/tcl/bug-procs.tcl	3 Oct 2003 16:54:37 -0000	1.7
@@ -800,27 +800,8 @@
                  label $action(pretty_name) \
                  values $values \
                  null_label "Unassigned" \
-                 where_clause "
-                     exists (select 1
-                             from   workflow_case_assigned_actions aa,
-                                    workflow_case_role_user_map crum
-                             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
-                            )
-                 " \
-                 null_where_clause "
-                     exists (select 1
-                             from   workflow_case_assigned_actions aa,
-                                    workflow_case_role_user_map crum
-                             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
-                            )"]
+                 where_clause [db_map filter_assignee_where_clause] \
+                 null_where_clause [db_map filter_assignee_null_where_clause]]
     }
 
     # Stat: By Component
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.3 -r1.4
--- openacs-4/packages/bug-tracker/tcl/bug-procs.xql	28 Sep 2003 01:28:18 -0000	1.3
+++ openacs-4/packages/bug-tracker/tcl/bug-procs.xql	3 Oct 2003 16:54:37 -0000	1.4
@@ -121,5 +121,19 @@
   </querytext>
 </fullquery>
  
+  <partialquery name="bug_tracker::bug::get_list.filter_assignee_where_clause">
+      <querytext>
+          exists (select 1
+                  from   workflow_case_assigned_actions aa,
+                         workflow_case_role_user_map crum
+                  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
+                 )
+      </querytext>
+  </partialquery>
+
 </queryset>