Index: openacs-4/packages/imsld/www/admin/index.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/www/admin/index.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/imsld/www/admin/index.xql	1 Feb 2006 11:38:23 -0000	1.1
+++ openacs-4/packages/imsld/www/admin/index.xql	16 May 2006 09:24:36 -0000	1.2
@@ -6,8 +6,9 @@
     select imsld.imsld_id,
     coalesce(imsld.title, imsld.identifier) as imsld_title,
     cr3.item_id,
-    cr3.live_revision
-    from cr_items cr1, cr_items cr2, cr_items cr3, cr_items cr4,
+    cr3.live_revision,
+    to_char(ao.creation_date,'MM/DD/YYYY HH24:MI') as creation_date 
+    from cr_items cr1, cr_items cr2, cr_items cr3, cr_items cr4, acs_objects ao,
     imsld_cp_manifests icm, imsld_cp_organizations ico, imsld_imsldsi imsld 
     where cr1.live_revision = icm.manifest_id
     and cr1.parent_id = cr4.item_id
@@ -16,8 +17,44 @@
     and imsld.organization_id = cr2.item_id
     and cr2.live_revision = ico.organization_id
     and cr3.item_id = imsld.item_id
+    and cr3.item_id = ao.object_id
+    $imsld_orderby
 
 		</querytext>
 	</fullquery>
+
+	<fullquery name="get_runs">
+		<querytext>
+
+        select run.run_id,
+        run.status,
+        coalesce(imsld.title, imsld.identifier) as imsld_title,
+	    to_char(ao.creation_date,'MM/DD/YYYY HH24:MI') as creation_date
+        from cr_items cr1, cr_items cr2, cr_items cr3, cr_items cr4, acs_objects ao,
+        imsld_runs run, imsld_cp_manifests icm, imsld_cp_organizations ico, imsld_imsldsi imsld 
+        where run.imsld_id = imsld.imsld_id
+        and ao.object_id = run.run_id
+        and cr1.live_revision = icm.manifest_id
+        and cr1.parent_id = cr4.item_id
+        and cr4.parent_id = :cr_root_folder_id
+        and ico.manifest_id = cr1.item_id
+        and imsld.organization_id = cr2.item_id
+        and cr2.live_revision = ico.organization_id
+        and cr3.live_revision = imsld.imsld_id
+        $run_orderby
+
+		</querytext>
+	</fullquery>
+
+	<fullquery name="make_run_live">
+		<querytext>
+
+        update imsld_runs
+        set status = 'active'
+        where run_id = :set_run_id_live
+    
+		</querytext>
+	</fullquery>
+
 </queryset>