Hide an entitlement/role in ARS request based on Requestee attribute fields

[biswajitoram]

Hi Team,

We want to hide a specific entitlement and are only available to request if the requestee/user has country= 'Thailand' AND location = 'Office' attributes in their profile and the rest of the entitlements/roles will be available for all to request.

And I have tried with this query Config for Requestable Entitlement in ARS

query:  ev.customproperty20 in (select country from Users where userkey in (${requestee})) AND ev.customproperty21 in (select location from Users where userkey in (${requestee}))

also updated customproperty20= 'Thailand' and customproperty21 = 'Office' the entitlement other attributes

[sudeshjaiswal]

Hello @biswajitoram ,

This way it may not work..

did you try to configure dynamic attribute so that user can select country thailand or others location as office or others, based on that the entitlements will be displayed.

[rushikeshvartak]

Possible solutions

• Create dynamic attribute and use in entitlement type filter
• Use Entitlement customproperty to achieve use case

[biswajitoram]

Hi @rushikeshvartak @sudeshjaiswal 

Thanks for your support.

1. I have achieved this without going for the Dynamic attributes. PFA the query I have used.

query:- ev.entitlement_value not like 'entitlement_value' OR (ev.customproperty20 in (select country from Users where userkey in (${requestee})) AND ev.customproperty21 in (select location from Users where userkey in (${requestee})))

I have updated the CP20 = CountryName and CP21 = LocationName

2. But we have another requirement with this. We want to restrict another entitlement same as the above.  I have tried with multiple options but getting this error.

Not sure how can I restrict both entitlements EntA and EntB or multiple entitlements. I have tried to update the CP20 AND 21 values for EntB same as EntA, but still not working.

Could you please help me with the query?

[rushikeshvartak]

Can you explain with example

[biswajitoram]

Hi @rushikeshvartak 

The earlier requirement was that only EntA can be requestable in ARS only by users with country= "CountryA" and location = "LocationA". And I have achieved this requirement by below query:

query:- ev.entitlement_value not like 'EntA' OR (ev.customproperty20 in (select country from Users where userkey in (${requestee})) AND ev.customproperty21 in (select location from Users where userkey in (${requestee})))

So, now the new requirement is EntB also can be requestable in ARS only by users with country= "CountryA" and location = "LocationA" same as the previous requirement.

I have tried merging different queries but I am getting the error as I mentioned earlier.

Could you please help me with the query?

[rushikeshvartak]

Share logs