DW Roles to populate the user in a cabinet field "approver"-1517849502

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

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

i will give that a try ....keith