I have a scenario, where the request should go for the "Security Group Owners" for the Approval and Any Owner can approve it.
I am using the "Custom Assignment" component in the Workflow but the request is directly going to ADMIN.
I am using 'usergroup_owners' table in the query.
Please let me know which value should I choose in the "Select User Field" attribute and what query should I write in "User Group" attribute of the Custom Assigment component of the workflow.
It is a User group.
The query I'm using is:
Select User Field: Custom Query
User Group: select userkey from usergroup_owners where usergroupkey==8
The Access Request approval should go to any of the owners of the usergroup as per the above query. But it is going to the admin.
Where I did the mistake, please let me know.
Hi @Saviynt_Savvy ,
Can you share the screenshot of your workflow along with the complete logs? Also, please make sure the "select user field" in the custom assignment block should be CustomQuery.
From the above screenshot I can see you are using double equals (==) in your query. Please use single equals like below.
select userkey from usergroup_owners where USERGROUPKEY=3