Index: openacs-4/packages/logger/www/admin/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/logger/www/admin/index-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/logger/www/admin/index-postgresql.xql	7 May 2003 16:43:41 -0000	1.1
+++ openacs-4/packages/logger/www/admin/index-postgresql.xql	8 May 2003 13:56:04 -0000	1.2
@@ -22,4 +22,37 @@
     </querytext>
   </fullquery>
 
+  <fullquery name="select_variables">
+    <querytext>
+        select lv.variable_id,
+             lv.name,
+             lv.unit,
+             lv.type,
+             acs_permission__permission_p(lv.variable_id, :user_id, 'admin') as admin_p
+        from logger_variables lv
+        where (exists (select 1
+                         from logger_project_var_map lpvm,
+                         logger_project_pkg_map lppm
+                       where lv.variable_id = lpvm.variable_id
+                         and lpvm.project_id = lppm.project_id
+                         and lppm.package_id = :package_id
+                   )
+        or lv.package_id = :package_id
+        or lv.package_id is null)    
+    </querytext>
+  </fullquery>
+
+  <fullquery name="select_mappable_projects">
+    <querytext>
+        select p.project_id,
+               p.name
+        from   logger_projects p
+        where  not exists (select 1
+                           from   logger_project_pkg_map ppm
+                           where  ppm.project_id = p.project_id
+                           and    ppm.package_id = :package_id)
+        and    acs_permission__permission_p(p.project_id, :user_id, 'read') = 't'
+    </querytext>
+  </fullquery>
+
 </queryset>