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.4 -r1.5 --- openacs-4/packages/dotlrn-homework/www/folder-chunk-oracle.xql 29 Jun 2004 10:18:11 -0000 1.4 +++ openacs-4/packages/dotlrn-homework/www/folder-chunk-oracle.xql 12 Jul 2004 14:49:57 -0000 1.5 @@ -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