Index: openacs-4/packages/dotlrn-homework/www/folder-chunk-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-homework/www/folder-chunk-oracle.xql,v diff -u -r1.2.2.1.4.2 -r1.2.2.1.4.3 --- openacs-4/packages/dotlrn-homework/www/folder-chunk-oracle.xql 26 May 2004 15:48:12 -0000 1.2.2.1.4.2 +++ openacs-4/packages/dotlrn-homework/www/folder-chunk-oracle.xql 6 Jul 2004 21:44:22 -0000 1.2.2.1.4.3 @@ -24,10 +24,11 @@ start with item_id in ([join $list_of_folder_ids ", "]) connect by parent_id = prior item_id) fs_tree where o.object_id = fs_tree.item_id - and c.user_id(+) = o.creation_user + and c.user_id(+) = o.creation_user and f.folder_id(+) = fs_tree.item_id $qualify_by_owner and r.item_id(+) = fs_tree.item_id + and r.item_id(+) = fs_tree.live_revision and rels.item_id(+) = o.object_id and rels.relation_tag(+) = 'homework_correction' and not exists (select 1