Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/22/2024 10:10 PM
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
10/22/2024 10:18 PM - edited 10/22/2024 10:28 PM
@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
10/23/2024 07:23 AM
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