cancel
Showing results for 
Search instead for 
Did you mean: 

Escape underscore (_) in Entitlement Type - Config for Requestable Entitlement in ARS

Srikanth
New Contributor
New Contributor

Hi,

I am looking for a way to escape underscore (_) in the config for requestable entitlements at the entitlement type show page.

For example there are entitlements which start with "Z_" and we only want to display which satisfy the condition ev.status = 1 and ev.entitlement_value like 'Z_%', when this is used at the config level, Saviynt is not able to provide exact result set at entitlements display popup at request access.

Note - if you escape the underscore it works at db analyzer but not at the cofig level as it treats it as "Invalid SQL syntax error"

Srikanth_1-1669286889452.png

Srikanth_0-1669286871775.png

Has anyone been able to find a workaround. Appreciate any inputs.

Thanks.

6 REPLIES 6

rushikeshvartak
All-Star
All-Star

ev.status=1 and replace (ev.entitlement_value,’_’,’’) like ‘Z%’

Srikanth
New Contributor
New Contributor

Doesnt work

Srikanth_0-1669302428036.png

Secondly, the replace function is not the option as we have to show ent vals starting with "Z_"

That will work just change ‘ to proper single quote

Srikanth
New Contributor
New Contributor

Doesnt filter the ent values as expected

Srikanth_1-1669303925639.png

ev.status=1 and replace(ev.entitlement_value,'_','') like 'Z%' and ev.entitlementtypekey=16

Srikanth_0-1669303470548.png

It works on db analyser if you are mentioning that

Srikanth_0-1669303910724.png

ev.status=1 and replace(ev.entitlement_value,'_',':::') like 'Z:::%' and ev.entitlementtypekey=16