Index: openacs-4/packages/assessment/www/asm-admin/request-notification.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/asm-admin/request-notification.tcl,v diff -u -N -r1.7 -r1.8 --- openacs-4/packages/assessment/www/asm-admin/request-notification.tcl 8 Mar 2018 08:16:56 -0000 1.7 +++ openacs-4/packages/assessment/www/asm-admin/request-notification.tcl 29 May 2018 18:06:33 -0000 1.8 @@ -91,8 +91,19 @@ label "[_ notifications.Delivery_Method]" } } -db_multirow notify_users notify_users {} +db_multirow -extend {name} notify_users notify_users { + select nr.user_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 notification_requests nr + where nr.object_id = :inter_item_check_id +} { + set name [acs_user::get_element -user_id $user_id -element name] +} + # Local variables: # mode: tcl # tcl-indent-level: 4