Hi All,
[Version 7.0.1.116052]
I'm facing a issue with fulfillment Workflow :
e.g. Request Submitted for user : Kathleen, Allison
Details passed in provisioning command & SQL query has AveksaAdmin details. (UserID, FN, LN, etc...)
Not Sure, what is missing. Below screenshot has runtime data and query.
Regards
Tahir Ahmed
The SQL query should be adjusted.
In your SQL query you are using the userId of the requstor (${access_request_meu_userId}) while you need the userId of the user (${access_request_cri_meu_userId})
When choosing Change Request -> Requestor -> Id, the workflow variable is: ${access_request_meu_userId}
When choosing Change Request -> User-> Id, the workflow variable is: ${access_request_cri_meu_userId}
(screen shot below)
Thanks Boris. Adding _cri_ to the variable resolves to user in CR.
However, I have this Issue!! as per below screenshot. when we choose this way.. the variables generated by workflow editor on my version were without _cri_ e.g. ${access_request_meu_userId}
What you are describing is a very similar issue which was fixed is 7.0.1 P1
The SQL query should be adjusted.
In your SQL query you are using the userId of the requstor (${access_request_meu_userId}) while you need the userId of the user (${access_request_cri_meu_userId})
When choosing Change Request -> Requestor -> Id, the workflow variable is: ${access_request_meu_userId}
When choosing Change Request -> User-> Id, the workflow variable is: ${access_request_cri_meu_userId}
(screen shot below)