How to approve/reject or respond a notification through script
BEGIN
wf_notification.setattrtext (nid => '4754620',
aname => 'RESULT',
avalue => 'REJECTED'
);
wf_notification.respond (nid => '4754620',
respond_comment => 'Reject From backend',
responder => 'XXTEST');
COMMIT;
END;
nid = will be notification id
There are multiple ways to get notification id
- Open the notification in the application through SYSADMIN or any other user
in the notification below sent and to date, you can see the ID
or
- you can search the notification in wf_notification table
aname = will be always RESULT
avalue = will be APPROVE,REJECTED or any other action .
Generally for avalue , perform the appropriate action on the notification through front end
and see the value of RESULT attribute in wf_notification_attributes table.
responder coment = any comment
responder => will be recipient role/user name
No comments:
Post a Comment