Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/static-assignments-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/static-assignments-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/static-assignments-postgresql.xql	14 May 2001 23:16:08 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/static-assignments-postgresql.xql	17 May 2001 04:34:40 -0000	1.2
@@ -15,11 +15,7 @@
              left outer join
            wf_context_assignments ca 
              on (tr.context_key = ca.context_key and 
-                  tr.transition_key = ca.transition_key and
-                  tr.workflow_key = :workflow_key and 
-                  tr.context_key = :context_key and    
-                  tr.trigger_type = 'user' and    
-                  tr.assignment_callback is null) 
+                  tr.transition_key = ca.transition_key) 
              left outer join 
            parties p 
              using (party_id) 
@@ -28,6 +24,10 @@
                 from   wf_transition_assignment_map 
                 where  workflow_key = tr.workflow_key
                 and    assign_transition_key = tr.transition_key)
+      and  tr.workflow_key = :workflow_key
+      and  tr.context_key = :context_key
+      and  tr.trigger_type = 'user'
+      and  tr.assignment_callback is null
     order by tr.sort_order, tr.transition_key
 
       </querytext>