Index: openacs-4/packages/workflow/workflow.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/workflow.info,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/workflow/workflow.info	1 Sep 2003 13:43:50 -0000	1.7
+++ openacs-4/packages/workflow/workflow.info	28 Sep 2003 01:24:26 -0000	1.8
@@ -8,7 +8,7 @@
     <singleton-p>t</singleton-p>
     <auto-mount>workflow</auto-mount>
 
-    <version name="1.0d5" url="http://openacs.org/repository/download/apm/workflow-1.0d5.apm">
+    <version name="1.1d1" url="http://openacs.org/repository/download/apm/workflow-1.1d1.apm">
     <database-support>
         <database>oracle</database>
         <database>postgresql</database>
@@ -22,7 +22,7 @@
 &lt;p&gt;
 For more information, see: &lt;a href=&quot;http://www.collaboraid.biz/developer/workflow-spec&quot;&gt;the workflow specification&lt;/a&gt;.</description>
 
-        <provides url="workflow" version="1.0d5"/>
+        <provides url="workflow" version="1.1d1"/>
         <requires url="notifications" version="0.3d"/>
         <requires url="acs-content-repository" version="4.6d1"/>
         <requires url="acs-kernel" version="4.6.2"/>
Index: openacs-4/packages/workflow/sql/oracle/workflow-tables-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/sql/oracle/workflow-tables-create.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/workflow/sql/oracle/workflow-tables-create.sql	1 Sep 2003 13:43:51 -0000	1.4
+++ openacs-4/packages/workflow/sql/oracle/workflow-tables-create.sql	28 Sep 2003 01:24:26 -0000	1.5
@@ -1,4 +1,4 @@
--- Data model for the workflow package, part of the OpenACS system.
+>-- Data model for the workflow package, part of the OpenACS system.
 --
 -- @author Lars Pind (lars@collaboraid.biz)
 -- @author Peter Marklund (peter@collaboraid.biz)
@@ -514,3 +514,24 @@
 end;
 /
 show errors
+
+-----------------
+-- Useful views
+-----------------
+
+create or replace view workflow_case_assigned_actions as 
+    select c.workflow_id,
+           c.case_id, 
+           c.object_id,
+           a.action_id, 
+           a.assigned_role as role_id
+    from   workflow_cases c,
+           workflow_case_fsm cfsm,
+           workflow_actions a,
+           workflow_fsm_action_en_in_st aeis
+    where  cfsm.case_id = c.case_id
+    and    a.always_enabled_p = 'f'
+    and    aeis.state_id = cfsm.current_state
+    and    aeis.assigned_p = 't'
+    and    a.action_id = aeis.action_id
+    and    a.assigned_role is not null;
Index: openacs-4/packages/workflow/sql/oracle/upgrade/upgrade-1.0d5-1.1d1.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/sql/oracle/upgrade/upgrade-1.0d5-1.1d1.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/workflow/sql/oracle/upgrade/upgrade-1.0d5-1.1d1.sql	28 Sep 2003 01:24:26 -0000	1.1
@@ -0,0 +1,27 @@
+--
+-- Upgrade script
+--
+-- Adds useful views
+--
+-- @author Lars Pind (lars@collaboraid.biz)
+--
+-- @cvs-id $Id: upgrade-1.0d5-1.1d1.sql,v 1.1 2003/09/28 01:24:26 lars Exp $
+
+
+create or replace view workflow_case_assigned_actions as 
+    select c.workflow_id,
+           c.case_id, 
+           c.object_id,
+           a.action_id, 
+           a.assigned_role as role_id
+    from   workflow_cases c,
+           workflow_case_fsm cfsm,
+           workflow_actions a,
+           workflow_fsm_action_en_in_st aeis
+    where  cfsm.case_id = c.case_id
+    and    a.always_enabled_p = 'f'
+    and    aeis.state_id = cfsm.current_state
+    and    aeis.assigned_p = 't'
+    and    a.action_id = aeis.action_id
+    and    a.assigned_role is not null;
+
Index: openacs-4/packages/workflow/sql/postgresql/workflow-tables-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/sql/postgresql/workflow-tables-create.sql,v
diff -u -r1.11 -r1.12
--- openacs-4/packages/workflow/sql/postgresql/workflow-tables-create.sql	1 Sep 2003 13:43:51 -0000	1.11
+++ openacs-4/packages/workflow/sql/postgresql/workflow-tables-create.sql	28 Sep 2003 01:24:27 -0000	1.12
@@ -528,3 +528,24 @@
   'entry_rev_id',                    -- id_column
   null                               -- name_method
 );
+
+-----------------
+-- Useful views
+-----------------
+
+create or replace view workflow_case_assigned_actions as 
+    select c.workflow_id,
+           c.case_id, 
+           c.object_id,
+           a.action_id, 
+           a.assigned_role as role_id
+    from   workflow_cases c,
+           workflow_case_fsm cfsm,
+           workflow_actions a,
+           workflow_fsm_action_en_in_st aeis
+    where  cfsm.case_id = c.case_id
+    and    a.always_enabled_p = 'f'
+    and    aeis.state_id = cfsm.current_state
+    and    aeis.assigned_p = 't'
+    and    a.action_id = aeis.action_id
+    and    a.assigned_role is not null;
Index: openacs-4/packages/workflow/sql/postgresql/upgrade/upgrade-1.0d5-1.1d1.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/sql/postgresql/upgrade/upgrade-1.0d5-1.1d1.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/workflow/sql/postgresql/upgrade/upgrade-1.0d5-1.1d1.sql	28 Sep 2003 01:24:27 -0000	1.1
@@ -0,0 +1,26 @@
+--
+-- Upgrade script
+--
+-- Adds useful views
+--
+-- @author Lars Pind (lars@collaboraid.biz)
+--
+-- @cvs-id $Id: upgrade-1.0d5-1.1d1.sql,v 1.1 2003/09/28 01:24:27 lars Exp $
+
+
+create or replace view workflow_case_assigned_actions as 
+    select c.workflow_id,
+           c.case_id, 
+           c.object_id,
+           a.action_id, 
+           a.assigned_role as role_id
+    from   workflow_cases c,
+           workflow_case_fsm cfsm,
+           workflow_actions a,
+           workflow_fsm_action_en_in_st aeis
+    where  cfsm.case_id = c.case_id
+    and    a.always_enabled_p = 'f'
+    and    aeis.state_id = cfsm.current_state
+    and    aeis.assigned_p = 't'
+    and    a.action_id = aeis.action_id
+    and    a.assigned_role is not null;