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>