Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/assignee-add-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/assignee-add-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/contrib/obsolete-packages/acs-workflow/www/assignee-add-postgresql.xql	14 May 2001 23:16:08 -0000	1.2
+++ openacs-4/contrib/obsolete-packages/acs-workflow/www/assignee-add-postgresql.xql	19 Nov 2001 18:27:40 -0000	1.3
@@ -1,4 +1,5 @@
 <?xml version="1.0"?>
+
 <queryset>
    <rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
@@ -8,9 +9,14 @@
     select p.party_id,
            acs_object__name(p.party_id) as name,
            p.email
-    from   parties p
-    where  not exists (select 1 from wf_task_assignments ta where ta.task_id = :task_id and ta.party_id = p.party_id)
+      from parties p
+     where not exists (select 1 from wf_task_assignments ta where ta.task_id = :task_id and ta.party_id = p.party_id)
+       and 0 < (select count(*)
+                from   users u, party_approved_member_map m
+                where  m.party_id = p.party_id
+                and    u.user_id = m.member_id)
 
+
       </querytext>
 </fullquery>