SAVROLE limiting access to certain users and certain request options

[venkat]

Use case:-

We want to limit a user with savrole  Sav-limit-access to only submit cases for certain users. They should be able to select only certain users and submit RequestAccessforOthers,  ViewExistingAccess, RequestEnterpriseRoles

We have configured the following HQL in a sav role for Whom to Request

[{"for":"RequestAccessforOthers,ViewExistingAccess","query":"select a from users a where (a.customproperty11 like 'GXXXXX' or a.customproperty13 like '%xxx%') and a.statuskey = 1"}]

we have the following feature in the sav role added 

Request Enterprise Roles- Classic Experience

We can search for users that meet the conditions above for Request access for others and view existing access.  We cannot search for users that meet above conditions for RequestEnterpriseRoles

how can we acheive this.  

i tried the following and it did not work

[{"for":"RequestAccessforOthers,ViewExistingAccess,RequestEnterpriseRoles","query":"select a from users a where (a.customproperty11 like 'GXXXXX' or a.customproperty13 like '%xxx%') and a.statuskey = 1"}]

please advise

[rushikeshvartak]

Issue is U should be capital in table name

[{"for":"RequestAccessforOthers,ViewExistingAccess","query":"select a from Users a where (a.customproperty11 like 'GXXXXX' or a.customproperty13 like '%xxx%') and a.statuskey = 1"}]

My configs 

[{"for":"RequestAccessforOthers","query":"select a from Users a where a.username='137658' and a.statuskey=1"},{"for":"ViewExistingAccess","query":"select a from Users a where a.username='137658' and statuskey=1"},{"for":"RequestEnterpriseRoles","query":"select a from Users a where a.username='137658' and statuskey=1"}]