Advanced Query in SAVRole is not working

[varunpuri]

Hi,

We have created a custom SAVRole  and have done the following configuration in it - 

The query in HQL which we have used is this : 
select a from Users a where a.id in (select us.userkey from User_accounts us, Accounts cc where us.accountkey=cc.id and (cc.endpointkey = 139 or cc.endpointkey = 140) and (lower(cc.status)='1' or lower(cc.status)='manually provisioned' or lower(cc.status)='active'))

We have given this SAVRole to a user.

Now, we have logged into Saviynt dev tenant using this user and are trying to access the "Request Access for Others" feature. But no user is getting displayed there. Instead, in the logs, we get this error :

ERROR","An error occurred :|java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: User_accounts is not mapped [select count(*) as total from com.saviynt.ssm.entity.Users a where  a.id 

Appreciate your help here.

Best Regards,

Varun

[rushikeshvartak]

You can't use user_accounts table in sav role advanced config

[varunpuri]

Thank You, @rushikeshvartak for your response.

Is there any alternate way to achieve it ? This custom sav role has to be assigned to the endpoint owner and the use case to be achieved is this :

If the endpoint owner logs in and navigates to "Request Access for Others" then, he/she should be able to see only those Identities which have accounts on the endpoint for which this person is the owner.

Best Regards,
Varun

[rushikeshvartak]

You need to use users customproperty and store endpointkey and try logic

[Darshanjain]

HI @varunpuri 

Can you let me know in which version you are trying if its 23.10 or 23.11 it should work fine.

Thanks

Darshan

[varunpuri]

Hello @Darshanjain ,

I am trying this on version 23.11. Can you please suggest some corrections.

Best Regards,
Varun

[Darshanjain]

Hi @Varun 

As discussed, use the Classic UI ( beta ) for the time being and from 23.12 you will see the new Gen2 UI where it will work with advance filter.

Thanks

Darshan

[rushikeshvartak]

Gen2 Beta version