Index: openacs-4/packages/dotlrn-homework/www/folder-chunk-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-homework/www/folder-chunk-postgresql.xql,v diff -u -r1.2.2.1 -r1.2.2.2 --- openacs-4/packages/dotlrn-homework/www/folder-chunk-postgresql.xql 3 Apr 2004 00:22:06 -0000 1.2.2.1 +++ openacs-4/packages/dotlrn-homework/www/folder-chunk-postgresql.xql 13 Apr 2004 18:46:41 -0000 1.2.2.2 @@ -27,7 +27,7 @@ join acs_objects o on (o.object_id = fs_tree.item_id) left join cr_folders f on (f.folder_id = fs_tree.item_id) left join persons p on (p.person_id = o.creation_user) - left join cr_revisions r on (r.revision_id = fs_tree.item_id) + left join cr_revisions r on (r.revision_id = fs_tree.latest_revision) left join cr_item_rels rels on (rels.item_id = o.object_id and rels.relation_tag = 'homework_correction') where not exists (select 1