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 -N -r1.12 -r1.13
--- openacs-4/packages/workflow/tcl/case-procs-postgresql.xql	17 Sep 2013 14:37:38 -0000	1.12
+++ openacs-4/packages/workflow/tcl/case-procs-postgresql.xql	21 Nov 2017 13:05:13 -0000	1.13
@@ -2,42 +2,6 @@
 <queryset>
   <rdbms><type>postgresql</type><version>7.2</version></rdbms>
 
-  <fullquery name="workflow::case::fsm::get_info_not_cached.select_case_info">
-    <querytext>
-      select c.case_id,
-             c.workflow_id,
-             c.object_id,
-             s.state_id,
-             s.short_name as state_short_name,
-             s.pretty_name as pretty_state,
-             s.hide_fields as state_hide_fields
-      from   workflow_cases c,
-             workflow_case_fsm cfsm left outer join
-             workflow_fsm_states s on (s.state_id = cfsm.current_state) 
-      where  c.case_id = :case_id
-      and    cfsm.case_id = c.case_id
-      and    cfsm.parent_enabled_action_id = :parent_enabled_action_id
-    </querytext>
-  </fullquery>
-
-  <fullquery name="workflow::case::fsm::get_info_not_cached.select_case_info_null_parent_id">
-    <querytext>
-            select c.case_id,
-                   c.workflow_id,
-                   c.object_id,
-                   s.state_id,
-                   s.short_name as state_short_name,
-                   s.pretty_name as pretty_state,
-                   s.hide_fields as state_hide_fields
-            from   workflow_cases c,
-                   workflow_case_fsm cfsm left outer join
-                   workflow_fsm_states s on (s.state_id = cfsm.current_state) 
-            where  c.case_id = :case_id
-            and    cfsm.case_id = c.case_id
-            and    cfsm.parent_enabled_action_id is null
-    </querytext>
-  </fullquery>
-
   <fullquery name="workflow::case::role::get_assignees_not_cached.select_assignees">
     <querytext>
         select m.party_id, 
@@ -51,44 +15,6 @@
     </querytext>
   </fullquery>
 
-  <fullquery name="workflow::case::get_activity_log_info_not_cached.select_log">
-    <querytext>
-        select l.entry_id,
-               l.case_id,
-               l.action_id,
-               a.short_name as action_short_name,
-               a.pretty_past_tense as action_pretty_past_tense,
-               io.creation_user,
-               iou.first_names as user_first_names,
-               iou.last_name as user_last_name,
-               iou.email as user_email,
-               io.creation_date,
-               to_char(io.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date_pretty,
-               r.content as comment_string,
-               r.mime_type as comment_mime_type,
-               d.key,
-               d.value
-        from   workflow_case_log l join 
-               workflow_actions a using (action_id) join 
-               cr_items i on (i.item_id = l.entry_id) join 
-               acs_objects io on (io.object_id = i.item_id) left outer join 
-               acs_users_all iou on (iou.user_id = io.creation_user) join
-               cr_revisions r on (r.revision_id = i.live_revision) left outer join 
-               workflow_case_log_data d using (entry_id)
-        where  l.case_id = :case_id
-        order  by creation_date
-    </querytext>
-  </fullquery>
-
-  <fullquery name="workflow::case::timed_actions_sweeper.select_timed_out_actions">
-    <querytext>
-        select enabled_action_id
-        from   workflow_case_enabled_actions
-        where  execution_time <= current_timestamp
-        and    completed_p = 'f'
-    </querytext>
-  </fullquery>
-
   <fullquery name="workflow::case::action::notify.select_object_name">
     <querytext>
         select acs_object__name(:object_id) as name
@@ -139,34 +65,4 @@
     </querytext>
   </fullquery>
 
-  <fullquery name="workflow::case::action::enabled_p.select_enabled_p">
-    <querytext>
-      select 1
-      from   workflow_case_enabled_actions ean
-      where  ean.action_id = :action_id
-      and    ean.case_id = :case_id
-      and    completed_p = 'f'
-      limit 1
-    </querytext>
-  </fullquery>
-
-  <fullquery name="workflow::case::enabled_action_get.select_enabled_action">
-    <querytext>
-        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
-    </querytext>
-  </fullquery>    
-
 </queryset>