Index: openacs-4/packages/acs-templating/www/doc/demo/list1a/index-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-templating/www/doc/demo/list1a/index-oracle.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/acs-templating/www/doc/demo/list1a/index-oracle.xql 4 Feb 2006 19:09:15 -0000 1.1 +++ openacs-4/packages/acs-templating/www/doc/demo/list1a/index-oracle.xql 10 Feb 2006 01:21:45 -0000 1.2 @@ -4,28 +4,29 @@ - select template_demo_note_id, title, body, - decode(acs_permission.permission_p(template_demo_note_id, + select n.template_demo_note_id, + n.title, + n.body, + decode(acs_permission.permission_p(n.template_demo_note_id, :user_id, 'write'), 't', 1, 'f', 0) as write_p, - decode(acs_permission.permission_p(template_demo_note_id, + decode(acs_permission.permission_p(n.template_demo_note_id, :user_id, 'admin'), 't', 1, 'f', 0) as admin_p, - decode(acs_permission.permission_p(template_demo_note_id, + decode(acs_permission.permission_p(n.template_demo_note_id, :user_id, 'delete'), 't', 1, 'f', 0) as delete_p from template_demo_notes n, acs_objects o where n.template_demo_note_id = o.object_id - and o.context_id = :package_id and exists (select 1 from acs_object_party_privilege_map - where object_id = template_demo_note_id + where object_id = n.template_demo_note_id and party_id = :user_id and privilege = 'read') order by creation_date Index: openacs-4/packages/acs-templating/www/doc/demo/list1b/index-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-templating/www/doc/demo/list1b/index-oracle.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/acs-templating/www/doc/demo/list1b/index-oracle.xql 4 Feb 2006 19:09:15 -0000 1.1 +++ openacs-4/packages/acs-templating/www/doc/demo/list1b/index-oracle.xql 10 Feb 2006 01:21:45 -0000 1.2 @@ -4,28 +4,29 @@ - select template_demo_note_id, title, body, - decode(acs_permission.permission_p(template_demo_note_id, + select n.template_demo_note_id, + n.title, + n.body, + decode(acs_permission.permission_p(n.template_demo_note_id, :user_id, 'write'), 't', 1, 'f', 0) as write_p, - decode(acs_permission.permission_p(template_demo_note_id, + decode(acs_permission.permission_p(n.template_demo_note_id, :user_id, 'admin'), 't', 1, 'f', 0) as admin_p, - decode(acs_permission.permission_p(template_demo_note_id, + decode(acs_permission.permission_p(n.template_demo_note_id, :user_id, 'delete'), 't', 1, 'f', 0) as delete_p from template_demo_notes n, acs_objects o where n.template_demo_note_id = o.object_id - and o.context_id = :package_id and exists (select 1 from acs_object_party_privilege_map - where object_id = template_demo_note_id + where object_id = n.template_demo_note_id and party_id = :user_id and privilege = 'read') order by creation_date Index: openacs-4/packages/acs-templating/www/doc/demo/list3/index-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-templating/www/doc/demo/list3/index-oracle.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/acs-templating/www/doc/demo/list3/index-oracle.xql 6 Feb 2006 13:08:30 -0000 1.1 +++ openacs-4/packages/acs-templating/www/doc/demo/list3/index-oracle.xql 10 Feb 2006 01:21:45 -0000 1.2 @@ -35,7 +35,7 @@ where object_id = template_demo_note_id and party_id = :user_id and privilege = 'read') - order by creation_date + [template::list::orderby_clause -orderby -name notes] Index: openacs-4/packages/acs-templating/www/doc/demo/list4/index-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-templating/www/doc/demo/list4/index-oracle.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/acs-templating/www/doc/demo/list4/index-oracle.xql 9 Feb 2006 02:40:10 -0000 1.1 +++ openacs-4/packages/acs-templating/www/doc/demo/list4/index-oracle.xql 10 Feb 2006 01:21:45 -0000 1.2 @@ -35,7 +35,7 @@ where object_id = template_demo_note_id and party_id = :user_id and privilege = 'read') - order by creation_date + [template::list::orderby_clause -orderby -name notes] Index: openacs-4/packages/acs-templating/www/doc/demo/list5/index-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-templating/www/doc/demo/list5/index-oracle.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/acs-templating/www/doc/demo/list5/index-oracle.xql 9 Feb 2006 06:39:55 -0000 1.1 +++ openacs-4/packages/acs-templating/www/doc/demo/list5/index-oracle.xql 10 Feb 2006 01:21:45 -0000 1.2 @@ -35,7 +35,7 @@ where object_id = template_demo_note_id and party_id = :user_id and privilege = 'read') - order by creation_date + [template::list::orderby_clause -orderby -name notes] Index: openacs-4/packages/acs-templating/www/doc/demo/list6/index-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-templating/www/doc/demo/list6/index-oracle.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/acs-templating/www/doc/demo/list6/index-oracle.xql 10 Feb 2006 00:47:17 -0000 1.1 +++ openacs-4/packages/acs-templating/www/doc/demo/list6/index-oracle.xql 10 Feb 2006 01:21:46 -0000 1.2 @@ -35,7 +35,7 @@ where object_id = template_demo_note_id and party_id = :user_id and privilege = 'read') - order by creation_date + [template::list::orderby_clause -orderby -name notes]