Index: openacs-4/packages/cms/www/modules/workspace/assignments.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/www/modules/workspace/assignments.tcl,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/cms/www/modules/workspace/assignments.tcl	8 Jun 2001 01:44:53 -0000	1.2
+++ openacs-4/packages/cms/www/modules/workspace/assignments.tcl	22 Aug 2002 03:04:33 -0000	1.3
@@ -6,49 +6,7 @@
 
 set user_id [User::getID]
 
-template::query get_locked_tasks locked_tasks multirow "
-  select
-    types.pretty_name, 
-    obj.object_id item_id, 
-    content_item.get_title(obj.object_id) title,
-    task.task_id,
-    content_workflow.get_holding_user_name(task.task_id) holding_user_name,
-    to_char(task.hold_timeout,'Mon. DD, YYYY') hold_timeout,
-    assign.case_id, 
-    trans.transition_name, trans.transition_key,
-    to_char(dead.deadline,'Mon. DD, YYYY') deadline
-  from
-    acs_object_types types,
-    acs_objects obj,
-    wf_case_assignments assign,
-    wf_transitions trans, 
-    wf_tasks task,
-    wf_cases case,
-    wf_case_deadlines dead
-  where 
-    dead.case_id = case.case_id
-  and
-    dead.transition_key = task.transition_key
-  and
-    assign.party_id = :user_id
-  and
-    assign.case_id = task.case_id
-  and
-    assign.transition_key = task.transition_key
-  and 
-    task.state = 'started'
-  and
-    task.transition_key = trans.transition_key
-  and
-    assign.case_id = case.case_id
-  and
-    case.object_id = obj.object_id
-  and
-    types.object_type = content_item.get_content_type(obj.object_id)
-  and
-    task.holding_user ^= :user_id
-  order by
-    dead.deadline"
+db_multirow locked_tasks get_locked_tasks ""
 
 
 set page_title "Task Assignments"