Index: openacs-4/packages/dotlrn-fs/www/all-objects-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-fs/www/all-objects-postgresql.xql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/dotlrn-fs/www/all-objects-postgresql.xql	30 Jul 2002 12:27:47 -0000	1.1
+++ openacs-4/packages/dotlrn-fs/www/all-objects-postgresql.xql	27 Oct 2014 16:41:20 -0000	1.2
@@ -25,9 +25,9 @@
                                                                                                       and ap.package_key = :dotlrn_package_key)))
     and fs_objects.parent_id = fs_folders.folder_id
     and fs_objects.type <> 'folder'
-    and fs_objects.last_modified >= (sysdate - :n_past_days)
-    and 't' = acs_permission.permission_p(fs_objects.object_id, :user_id, 'read')
-    [ad_order_by_from_sort_spec $orderby $table_def]
+    and fs_objects.last_modified >= (now() - (:n_past_days || ' days')::interval)
+    and 't' = acs_permission__permission_p(fs_objects.object_id, :user_id, 'read')
+    [template::list::orderby_clause -name files -orderby]
         </querytext>
     </fullquery>