Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

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%’


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

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


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

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


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.