Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Read the announcement here.
This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
@nitishdas - Please try below:WHERE USERS.USERKEY IN (SELECT REQUESTEE.USERKEY FROM USERS REQUESTEE, USERS REQUESTORS, USER_ACCOUNTS UA, ACCOUNTS A WHERE REQUESTORS.USERKEY = UA.USERKEY AND A.ACCOUNTKEY = UA.ACCOUNTKEY AND A.STATUS IN ('ACTIVE', 1, ...
@nitishdas This will give results like below:The requestor must have the savroles mentionedThe requestee must have an account in the endpointkey=17requestee companyname must not be in - COMPANYNAME NOT IN ('AAA B2B Users')WHERE USERS.USERKEY IN (SELE...