Index: openacs-4/packages/cms/www/modules/workspace/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/www/modules/workspace/index-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/cms/www/modules/workspace/index-postgresql.xql	8 Jun 2001 01:44:53 -0000	1.1
+++ openacs-4/packages/cms/www/modules/workspace/index-postgresql.xql	19 Nov 2001 18:42:10 -0000	1.2
@@ -35,7 +35,9 @@
   and
     assign.case_id = task.case_id
   and
-    assign.transition_key = task.transition_key
+    assign.role_key = trans.role_key
+  and
+    task.transition_key = trans.transition_key
   and (
     task.state = 'enabled'
     or (task.state = 'started' and task.holding_user = :user_id)
@@ -55,3 +57,13 @@
 
  
 </queryset>
+
+
+
+
+
+
+
+
+
+