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

[Srikanth]

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"

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

Thanks.

[rushikeshvartak]

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

[Srikanth]

Doesnt work

[Srikanth]

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

[rushikeshvartak]

That will work just change ‘ to proper single quote

[Srikanth]

Doesnt filter the ent values as expected

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

It works on db analyser if you are mentioning that

[rushikeshvartak]

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