Index: openacs-4/packages/imsld/www/index.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/www/index.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/imsld/www/index.xql	4 Apr 2006 10:26:04 -0000	1.2
+++ openacs-4/packages/imsld/www/index.xql	19 Apr 2006 16:29:20 -0000	1.3
@@ -6,7 +6,8 @@
 	<fullquery name="get_manifests">
 		<querytext>
     select imsld.imsld_id,
-    coalesce(imsld.title, imsld.identifier) as imsld_title
+    coalesce(imsld.title, imsld.identifier) as imsld_title,
+    to_char(imsld.creation_date,'MM/DD/YYYY HH24:MI') as creation_date
     from cr_items cr1, cr_items cr2, cr_items cr3, cr_items cr4,
     imsld_cp_manifests icm, imsld_cp_organizations ico, imsld_imsldsi imsld 
     where cr1.live_revision = icm.manifest_id
@@ -16,6 +17,7 @@
     and imsld.organization_id = cr2.item_id
     and cr2.live_revision = ico.organization_id
     and cr3.live_revision = imsld.imsld_id
+    $orderby
 		</querytext>
 	</fullquery>
 </queryset>