Index: openacs-4/packages/imsld/lib/imsld-chunk.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/lib/imsld-chunk.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/imsld/lib/imsld-chunk.xql	29 May 2006 15:11:32 -0000	1.1
@@ -0,0 +1,29 @@
+<?xml version="1.0"?>
+<queryset>
+
+
+
+	<fullquery name="active_runs">
+		<querytext>
+
+        select run.run_id,
+        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
+        and run.status = 'active'
+        $orderby
+
+		</querytext>
+	</fullquery>
+</queryset>
+