Index: openacs-4/packages/chat/lib/transcripts.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/chat/lib/Attic/transcripts.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/chat/lib/transcripts.xql	24 Jun 2006 14:23:41 -0000	1.2
@@ -0,0 +1,13 @@
+<?xml version="1.0"?>
+<queryset>
+
+<fullquery name="list_transcripts">
+  <querytext>
+   select ct.transcript_id, ct.pretty_name, ao.creation_date
+    from chat_transcripts ct, acs_objects ao
+    where ct.transcript_id = ao.object_id and ct.room_id = :room_id
+    order by ao.creation_date desc
+ </querytext>
+</fullquery>
+
+</queryset>