Index: openacs-4/packages/notes/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notes/www/index-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/notes/www/index-postgresql.xql	3 May 2001 18:23:35 -0000	1.1
+++ openacs-4/packages/notes/www/index-postgresql.xql	10 Feb 2004 19:39:49 -0000	1.2
@@ -1,24 +1,28 @@
 <?xml version="1.0"?>
 <queryset>
-   <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+  <rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
-<fullquery name="notes">      
-      <querytext>
-  select note_id, owner_id, title, body,
-         case when acs_permission__permission_p(note_id,:user_id,'write')='t' 
-              then 1 else 0 end as write_p,
-         case when acs_permission__permission_p(note_id,:user_id,'admin')='t'
-			  then 1 else 0 end as admin_p,
-         case when acs_permission__permission_p(note_id,:user_id,'delete')='t'
-			  then 1 else 0 end as delete_p
-  from notes n, acs_objects o
-  where n.note_id = o.object_id
-  and o.context_id = :package_id
-  and acs_permission__permission_p(note_id, :user_id, 'read') = 't'
-  order by creation_date
+  <fullquery name="notes">      
+    <querytext>
 
-      </querytext>
-</fullquery>
+      select note_id, title, body,
+             case when acs_permission__permission_p(note_id,:user_id,'write')='t' 
+                  then 1 else 0 end as write_p,
+             case when acs_permission__permission_p(note_id,:user_id,'admin')='t'
+    			  then 1 else 0 end as admin_p,
+             case when acs_permission__permission_p(note_id,:user_id,'delete')='t'
+    			  then 1 else 0 end as delete_p
+      from notes n, acs_objects o
+      where n.note_id = o.object_id
+        and o.context_id = :package_id
+        and exists (select 1
+                    from acs_object_party_privilege_map
+                    where object_id = note_id
+                      and party_id = :user_id
+                      and privilege = 'read')
+      order by creation_date
 
+    </querytext>
+  </fullquery>
  
 </queryset>