Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/24/2024 09:49 PM
Hi.
I have an issue about workflow custom assignment to user attribute.
I set user's custom property1 as approver's username.
In workflow configuration, set custom property1 as user field.
And set this workflow to security system.
Then, do access request, but the request is not assigned to the user who is set in custom property1(assigned to another admin user).
Is my configuration wrong?
Best Regards,
10/24/2024 09:55 PM
@KK try setting userkey instead of username
2) select custom query in custom assignment block and write a query to pass approves userkey
Query
Select u1.userkey from users u, users u1 where u.customproperty1=u1.username
10/24/2024 11:09 PM
@NM
Thank you.
I set userkey instead of username, but request is not assigned to the appropriate user.
For 2nd option(Select u1.userkey from users u, users u1 where u.customproperty1=u1.username), also request is not assigned to the appropriate user. If I enter this query in data analyzer many records are hit and actually, request is assigned to many user.
I tried below query, but the request is is not assigned to the appropriate user.
select userkey from users where username = ${user.customproperty1}
Any other ideas?
Best Regards,
10/24/2024 11:42 PM
@KK you need to specify more conditions
Instead of userkey now keep username in users customproperty 1
Select u1.userkey from users u, users u1 where u.customproperty1=u1.username and u.userkey==${user.id}
@KK try this
10/24/2024 11:59 PM
@KK Can you try above query in CustomQuery select box check it.