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