Posted Mon, 05 Feb 2018 15:51:42 GMT by Keith Telford

In a workflow - How would l write to the cabinet the actual user of a role.  For example i have the role IT manager in user Admin -> Roles  ...but i would want my name "keith" to be written to the cabinet instead of my role "IT manager" Tryign to use the assign data to write back to the cabinet using the approver field in the cabinet ...

https://www.docuware.com/sites/default/files/forums-images/DWrole.JPG

Posted Mon, 05 Feb 2018 16:18:00 GMT by Phil Robson

I think you need to do sometyhing like this:
2 Global variable. GV_CurrentUser and GV_Role.
Use 2 seperate assign data steps.
1. Assign data - assign the Current User to the variable GV_CurrentUser.
2. In the second assignment step, create an External Data connection as follows:
Connection - Authentication
Table - DWUSER
Field - name
WHERE Clause:

rid in (SELECT rid FROM dwsystem.DWUSERTOROLE WHERE uid in (SELECT uid FROM dwsystem.DWUSER WHERE name = GV_UserName))

 

Phil Robson
Senior Director Support Americas

 

https://www.docuware.com/sites/default/files/forums-images/USER.png

https://www.docuware.com/sites/default/files/forums-images/WHERE.png

Posted Mon, 05 Feb 2018 17:22:28 GMT by Keith Telford

i will give that a try ....keith

You must be signed in to post in this forum.