Workflow Custom Assignment to User Attribute

[KK]

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,

[NM]

@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

[KK]

@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,

[NM]

@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 

[Raghu]

@KK  Can you try above query in CustomQuery select box check it.

[KK]

@NM @Raghu 
Thank you.
I set as it, but request is not assigned to the appropriate user.

Any other ideas?

Best Regards,

[NM]

@KK share workflow wiring ss

[Raghu]

Cp1 is accountname or Global id ? share screenshot below query scrneshot sample 2 users  and now your workflow ss

Select username,customproperty1,systemusername,userkey from users where username in (cp1)