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.
Hi,We have the custom SAV Role in our Saviynt instance.We have the "Whom to request" query as - select a from Users a where a.customer in (select customerkey from Organization_Owners where userkey = '${users.id}' and policy='3' and rank='1') On logg...
Hi,We have a LDAP connection, which we are using the import users.I am trying to also have preprocessor query in import users in MODIFYUSERJSON which is :{"ADDITIONALTABLES": {"USERS": "SELECT username,employeeType FROM USERS"},"COMPUTEDCOLUMNS": ["e...
Hi,We have a requirement where we want to use the secondary organization for the users created using Saviynt user creation form.We have modified the GSP and we are able to add the secondary organization details in the user's custom properties. The ne...
Hi,We have a requirement where we want to show the endpoint if both the requestor as well as requestee (beneficiary user) has a particular SAV Role (Where rolename like '%CPO%').I was trying to have the below query, but this is not working :WHERE (us...
Hi,We have a requirement to create a SAV ROLE where the requestor can raise the request for users belong form the same organization.I have used the option advance query in "WHOM TO REQUEST" in SAV role and used query :select a from Users a where a.cu...
We tried with - [{"for":"RequestAccessforOthers,ViewExistingAccess,UpdateUserRequest","query":"select a from Users a where a.customer in (select customerkey from Organization_Owners where userkey = '${users.id}' and policy='3' and rank='1')"}]BUt thi...
The below query is working for me -where ${requestee.id} in (select distinct us.userkey from User_savroles us where us.rolekey in (select s.rolekey from Savroles s where s.rolename LIKE '%CPO%' or s.rolename LIKE '%RPO%' or s.rolename LIKE '%ORG%')) ...
Hi,I have mentioned the combined query above but this is not working. I have tried - WHERE (users.userkey in (SELECT DISTINCT us.userkey FROM User_savroles us JOIN SavRoles sr ON us.rolekey=sr.rolekey WHERE (sr.rolename LIKE '%CPO%' or sr.rolename LI...