Where are the details of the Actual Responder Details stored in the case of the below scenario
If a notification for one user was closed by another user through access to the first user's worklist, the name of the second user, who actually took the action, is displayed as the responder.
I am only able to find the Original Recipeint username in the wf_notifications table.
But where will the details of the Actual Responder name displayed in the notification be stored.
When I use the "wf_notification.Responder" function, I get the Original Recipeint username of the user but not the one who acted on the notification. Is there ANY way by which I can get the Actual responder user name who acted on the notification
select responder from wf_notifications where notification_id = <nid> also gives me the Original Recipeint username of the user but not the one who acted on the notification
When you use WF_NOTIFICATION.Responder you get the value of the column RESPONDER from WF_NOTIFICATIONS. When you use WF_NOTIFICATIONS.GetInfo(...) you get the ORIGINAL_RECIPIENT column.
Where exactly are you making your calls?
Edited by: Alejandro Sosa on Feb 13, 2013 7:43 AM
Edited by: Alejandro Sosa on Feb 13, 2013 7:44 AM
Thanks for the response.
Both the RESPONDER and the ORIGINAL_RECIPIENT Column show the same username.
The User who is approving the Notifications is having the access to the Worklist of the Original User through proxy.
He is the proxy of the Original User.
I think WF_ENGINE.context_proxy will store the actual user name who responds to the notification. But where does this actually store , i am not able to get.
We Need to find out the both the user names (one who received the notification , and the one who has approved it (in our case it is the user who has been set as a proxy and has access to the original user's work list) for the closed notifications.
In the Work flow Notification , it shows both the Original Recipeint and also the Actual Responder Name.
Since the worklist access is just allowing a proxy user to respond on behalf of the original user will appear as the responder/recipient. You can try using WF_COMMENTS.PROXY_USER for that notification. The proxy user should be there. This table is used to build the notification action history.
Hope this helps,