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
Index: openacs-4/packages/assessment/www/asm-admin/request-notification.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/asm-admin/Attic/request-notification.xql,v
diff -u -N
--- openacs-4/packages/assessment/www/asm-admin/request-notification.xql	1 Feb 2005 22:00:10 -0000	1.1
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,26 +0,0 @@
-<?xml version="1.0"?>
-<queryset>
-
-    <fullquery name="notify_users">
-        <querytext>
-        select p.first_names || ' ' || p.last_name as name,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 = :inter_item_check_id
-
-        </querytext>
-    </fullquery>
-
-    <fullquery name="get_name">
-        <querytext>
-	  select name from as_inter_item_checks where inter_item_check_id=:inter_item_check_id
-        </querytext>
-    </fullquery>
-
-
-
-</queryset>