Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/case-debug-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/case-debug-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/case-debug-postgresql.xql	3 May 2001 01:14:21 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/case-debug-postgresql.xql	19 Nov 2001 18:29:28 -0000	1.2
@@ -1,4 +1,5 @@
 <?xml version="1.0"?>
+
 <queryset>
    <rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
@@ -22,4 +23,21 @@
       </querytext>
 </fullquery>
 
+ 
+<fullquery name="dead_tokens">      
+      <querytext>
+      
+    select token_id, place_key, case_id, state, locked_task_id,
+           to_char(produced_date, 'YYYY-MM-DD HH24:MI:SS') as produced_date_pretty,
+           to_char(locked_date, 'YYYY-MM-DD HH24:MI:SS') as locked_date_pretty,
+           to_char(consumed_date, 'YYYY-MM-DD HH24:MI:SS') as consumed_date_pretty,
+           to_char(canceled_date, 'YYYY-MM-DD HH24:MI:SS') as canceled_date_pretty
+    from   wf_tokens
+    where  case_id = :case_id
+    and    state in ('consumed', 'canceled')
+
+      </querytext>
+</fullquery>
+
+ 
 </queryset>