Index: openacs-4/packages/acs-templating/www/doc/demo/list8/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-templating/www/doc/demo/list8/index-postgresql.xql,v
diff -u -N -r1.1 -r1.1.14.1
--- openacs-4/packages/acs-templating/www/doc/demo/list8/index-postgresql.xql	13 Feb 2006 12:37:53 -0000	1.1
+++ openacs-4/packages/acs-templating/www/doc/demo/list8/index-postgresql.xql	3 Jul 2016 17:51:04 -0000	1.1.14.1
@@ -16,14 +16,12 @@
 	acs_objects o,
 	persons p
       where n.template_demo_note_id = o.object_id
-	and p.person_id = o.creation_user
-        and exists (select 1
-                    from acs_object_party_privilege_map
-                    where object_id = n.template_demo_note_id
-                      and party_id = :user_id
-                      and privilege = 'read')
-	[template::list::filter_where_clauses -and -name notes]
+      and   p.person_id = o.creation_user
+      and   acs_permission__permission_p(n.template_demo_note_id, :user_id, 'read')
+      
+      [template::list::filter_where_clauses -and -name notes]
       [template::list::orderby_clause -orderby -name notes]
+      
     </querytext>
   </fullquery>
  
@@ -41,13 +39,11 @@
 	acs_objects o,
 	persons p
       where n.template_demo_note_id = o.object_id
-	and p.person_id = o.creation_user
-        and exists (select 1
-                    from acs_object_party_privilege_map
-                    where object_id = n.template_demo_note_id
-                      and party_id = :user_id
-                      and privilege = 'read')
-	[template::list::page_where_clause -and -name notes -key template_demo_note_id]
+      and   p.person_id = o.creation_user
+      and   acs_permission__permission_p(n.template_demo_note_id, :user_id, 'read')
+
+      [template::list::page_where_clause -and -name notes -key template_demo_note_id]
+      
     </querytext>
   </fullquery>