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>