Index: openacs-4/packages/cms/www/modules/workflow/overdue-items.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/www/modules/workflow/overdue-items.tcl,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/cms/www/modules/workflow/overdue-items.tcl	8 Jun 2001 01:44:53 -0000	1.2
+++ openacs-4/packages/cms/www/modules/workflow/overdue-items.tcl	22 Aug 2002 03:04:32 -0000	1.3
@@ -3,11 +3,7 @@
 
 
 if { ![string equal $transition "all"] } {
-    template::query get_transitoin_name transition_name onevalue "
-      select transition_name
-        from wf_transitions
-        where transition_key = :transition
-        and workflow_key = 'publishing_wf'"
+    set transition_name [db_string get_transition_name ""]
 
     set transition_sql "and ca.transition_key = :transition"
 
@@ -19,37 +15,6 @@
 
 set date_format "'Mon. DD, YYYY HH24:MI:SS'"
 
-template::query get_overdue_tasks overdue_tasks multirow "
-  select
-    ca.transition_key, transition_name, ca.party_id, 
-    item_id, content_item.get_title(item_id) as title,
-    nvl(party.name(ca.party_id),person.name(ca.party_id)) as assigned_party,
-    to_char(dead.deadline,'Mon. DD, YYYY') as deadline_pretty,
-    content_workflow.get_status(c.case_id, ca.transition_key) as status
-  from 
-    wf_transitions trans, wf_cases c, wf_case_deadlines dead, 
-    wf_case_assignments ca, cr_items i
-  where 
-    c.case_id = dead.case_id
-  and
-    c.case_id = ca.case_id
-  and
-    ca.transition_key = dead.transition_key
-  and
-    trans.transition_key = ca.transition_key
-  and
-    c.workflow_key = 'publishing_wf'
-  and
-    c.workflow_key = trans.workflow_key
-  and
-    c.state = 'active'
-  and 
-    c.object_id = i.item_id
-  and
-    content_workflow.is_overdue(c.case_id, ca.transition_key) = 't'
-  $transition_sql
-  order by
-    transition_name, dead.deadline desc, title, assigned_party"
+db_multirow overdue_tasks get_overdue_tasks ""
 
-
 set page_title "Outstanding Workflow Tasks - $transition_name"