Custom Assignment in Workflow

[Saviynt_Savvy]

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.

Thankyou,
Sumanth.

[armaanzahir]

Hi Sumanth,

Is the "Security Group" a usergroup on IGA or an entitlement of AD?

For writing any custom query, the Select User Field should be set as "CustomQuery"

Please refer to the below link to check the query format:

Workflow Components 

[Saviynt_Savvy]

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.

Thankyou,
Sumanth

[smitg]

Hi @Saviynt_Savvy ,

if you are using a query then
Select User Field : custom query
User Group : give your query here

Is the query resulting correct data in data analyzer?

Thanks,
Smitha

[Saviynt_Savvy]

not working.

[armaanzahir]

The query is incorrect. It has a double equal sign. 

The corrcet one is :

select userkey from usergroup_owners where usergroupkey=8

[Saviynt_Savvy]

still throwing error like "ERROR.FROM.ECM.SERVER" while I am submitting the request.

[naveenss]

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.

[Saviynt_Savvy]

The request is going for ADMIN approval, now.
Please let me know the query, so that it should go to the 'User Group Owners' for the access request approval.

[naveenss]

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

[Sandeep]

You are querying wrong table. Try "usergroup_users" table.

select userkey from usergroup_users where user_groupkey=3