"View existing access" from custom SAV Role

[prachi]

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 logging in with this user's SAV Role, and checking on "view existing access" tile, we are able to see the users list. on selecting one of the users from the list, the access for selected user is not displayed, instead the access for requestor is displayed.

We checked by selecting "Request for All" in the SAV role and then view existing access works so there is something missing with the query. 

Could you please help to debug this issue.

Thanks.

[rushikeshvartak]

use JSON instead of HQL

https://docs.saviyntcloud.com/bundle/EIC-Admin-v24x/page/Content/Chapter13-Access-Requests/ars-mang-...

[prachi]

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 this is not working.

Could you help with what could be the access query/JSON.

[rushikeshvartak]

How many sav role user have ? What is error in logs

[sk]

@prachi : Do you have any limitation on listing users under View Existing Access? If so what is your requirement? (I mean you don't want to show all users instead wanted to show limited users with certain criteria)

[rushikeshvartak]

[{"for":"RequestAccessforOthers,ViewExistingAccess,UpdateUserRequest","query":"select a from Users a where and a.id in (select userkey from Customer_Users where customerkey in (select customerkey from Organization_Owners where userkey = '${users.id}' and policy='3' and rank='1'))"}]