Index: openacs-4/packages/acs-admin/www/users/one.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/users/one.tcl,v diff -u -r1.20.2.2 -r1.20.2.3 --- openacs-4/packages/acs-admin/www/users/one.tcl 8 Apr 2019 12:58:18 -0000 1.20.2.2 +++ openacs-4/packages/acs-admin/www/users/one.tcl 3 Sep 2019 10:56:57 -0000 1.20.2.3 @@ -63,7 +63,16 @@ # XXX Make sure to make the following into links and this looks okay -db_multirow user_contributions user_contributions {} +db_multirow user_contributions user_contributions { + select at.pretty_name, + at.pretty_plural, + to_char(a.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date, + acs_object.name(a.object_id) as object_name + from acs_objects a, acs_object_types at + where a.object_type = at.object_type + and a.creation_user = :user_id + order by pretty_name, creation_date desc, object_name +} # cro@ncacasi.org 2002-02-20 # Boy is this query wacked, but I think I am starting to understand