Index: openacs-4/packages/notifications/www/request-notification.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/www/request-notification.tcl,v diff -u -N -r1.5 -r1.6 --- openacs-4/packages/notifications/www/request-notification.tcl 30 May 2018 14:55:47 -0000 1.5 +++ openacs-4/packages/notifications/www/request-notification.tcl 30 May 2018 15:06:53 -0000 1.6 @@ -126,7 +126,9 @@ } } -db_multirow notify_users notify_users {} +db_multirow -extend {name} notify_users notify_users {} { + set name [acs_user::get_element -user_id $request_user_id -element name] +} Index: openacs-4/packages/notifications/www/request-notification.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/www/request-notification.xql,v diff -u -N -r1.2 -r1.3 --- openacs-4/packages/notifications/www/request-notification.xql 30 May 2018 14:55:47 -0000 1.2 +++ openacs-4/packages/notifications/www/request-notification.xql 30 May 2018 15:06:53 -0000 1.3 @@ -3,14 +3,13 @@ - select p.first_names || ' ' || p.last_name as name,nr.request_id, + select nr.user_id as request_user_id, nr.request_id, (select name from notification_intervals where interval_id= nr.interval_id) as interval_name ,(select short_name from notification_delivery_methods where delivery_method_id=nr.delivery_method_id) as delivery_name - from persons p, notification_requests nr - where p.person_id = nr.user_id and - nr.object_id = :object_id and + from notification_requests nr + where nr.object_id = :object_id and nr.type_id = :type_id