05/31/2023 03:15 AM
Hi Team,
Requirement: Need to design a workflow like if user raise a request for new account only then it should be auto approved. If user raise a request for new account along with group/entitlement access then it should go to entitlement owner for approval. I have attached screen shot WF, which I was designed. seems its not working properly. (getting error page when I click on submit in ARS )
Prepared one custom query to get entitlement owner details based selected entitlement.
Please check and help me to resolve this issue.
05/31/2023 03:29 AM
05/31/2023 03:34 AM
@shivmano Thank you for response. Present I am using same workflow design (see attached screen) , but getting error page when submit the request through ARS page. I am not able to submit the request through ARS.
05/31/2023 03:41 AM
I am unable to view the attachment. would you be able to attach that in your message like I did
05/31/2023 04:55 AM - edited 05/31/2023 04:58 AM
05/31/2023 05:23 AM - edited 05/31/2023 05:26 AM
Seems like something might be breaking with the customquery. Can you try with the below queries
for entitlement owner:
select userkey from entitlement_owners where entitlement_valuekey=${REQUESTACCESSOBJ.id} and rank = 1
for role owner:
select userkey from role_owners where rolekey=${REQUESTACCESSOBJ.id} and rank = 1
Also, I believe if you need to just assign the request to role owner or entitlement owner of the requested item, then you can just use the Access Approval block unless your customquery is looking for something else
05/31/2023 05:51 AM
@shivmano I have tried with entitlement owner query in custom query job, but still getting error as below while submitting request for only new account through ARS.
05/31/2023 07:28 AM
Below workflow works fine for me as expected during both New Account and New account with entitlement. Probably, you need to check the logs to see if there is something else that is breaking