Index: openacs-4/packages/news-aggregator/www/subscriptions.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news-aggregator/www/subscriptions.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/news-aggregator/www/subscriptions.xql	28 Aug 2003 09:41:57 -0000	1.2
+++ openacs-4/packages/news-aggregator/www/subscriptions.xql	20 Mar 2004 11:12:29 -0000	1.3
@@ -2,19 +2,25 @@
 
 <queryset>
 
-    <fullquery name="sources">
-        <querytext>
-                    select title,
-			   source_id,
-			   feed_url,
-			   link,
-			   description,
-			   updates,
-                           to_char(last_scanned, 'YYYY-MM-DD HH24:MI:SS') as last_scanned
-                    from   na_sources
-                    where  owner_id = :user_id
-                    order  by lower(title)
-        </querytext>
+    <fullquery name="count_aggregators">
+          <querytext>
+            select count(*) 
+            from   na_aggregators a,
+                   acs_objects o
+            where  a.aggregator_id = o.object_id
+            and    o.creation_user = :user_id
+          </querytext>
     </fullquery>
 
+    <fullquery name="select_name">
+          <querytext>
+            select a.aggregator_name 
+            from   na_aggregators a, 
+                   acs_objects o 
+            where  o.object_id = a.aggregator_id
+            and    a.aggregator_id != :aggregator_id 
+            and    o.creation_user = :user_id
+          </querytext>
+    </fullquery>
+
 </queryset>