Query is not working as expected in custom assignment component in workflow.

[Munaf]

Hello All

We have enhancement request for mailbox approval. If the request is new, owner approval is required. If the owner or manager raised the request, approval is not required for modifications.

We are storing owner details in accounts.customproperty3

We need help to fetch the accounts.customproperty3 value in a custom assignment to send for approval.

We tried the query below to fetch account owner details, but it is not working as expected

select a.customproperty3 from accounts a,users u,user_accounts ua where u.userkey=ua.userkey 
and ua.accountkey=a.accountkey and a.endpointkey='221' and a.customproperty3 = u.email

[NM]

@Munaf what are you storing in customproperty 3 of accounts column ?

Name, username, userkey?

Try this 

select u.userkey from accounts a,users u where u.email=a.customproperty3 and a.endpointkey='221'

Above should work.

@@edited

[rushikeshvartak]

output of query should have alias as userkey

select a.customproperty3  as userkey from accounts a,users u,user_accounts ua where u.userkey=ua.userkey 
and ua.accountkey=a.accountkey and a.endpointkey='221' and a.customproperty3 = u.email