Index: openacs-4/packages/workflow/tcl/case-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/tcl/case-procs-postgresql.xql,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/workflow/tcl/case-procs-postgresql.xql 23 Jan 2004 11:02:27 -0000 1.7
+++ openacs-4/packages/workflow/tcl/case-procs-postgresql.xql 5 Feb 2004 10:37:33 -0000 1.8
@@ -38,15 +38,6 @@
-
-
- select cfsm.parent_enabled_action_id,
- cfsm.current_state as current_state_id
- from workflow_case_fsm cfsm
- where cfsm.case_id = :case_id
-
-
-
select m.party_id,
@@ -159,4 +150,23 @@
+
+
+ select enabled_action_id,
+ case_id,
+ action_id,
+ assigned_p,
+ completed_p,
+ parent_enabled_action_id,
+ to_char(execution_time, 'YYYY-MM-DD HH24:MI:SS') as execution_time_ansi,
+ coalesce((select a2.trigger_type
+ from workflow_case_enabled_actions e2,
+ workflow_actions a2
+ where e2.enabled_action_id = e.parent_enabled_action_id
+ and a2.action_id = e2.action_id), 'workflow') as parent_trigger_type
+ from workflow_case_enabled_actions e
+ where enabled_action_id = :enabled_action_id
+
+
+