11-24-2022 02:50 AM - edited 11-24-2022 02:57 AM
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.
11-24-2022 06:23 AM
11-24-2022 07:07 AM
11-24-2022 07:08 AM
Secondly, the replace function is not the option as we have to show ent vals starting with "Z_"
11-24-2022 07:10 AM
11-24-2022 07:28 AM - edited 11-24-2022 07:32 AM
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
11-24-2022 04:21 PM
ev.status=1 and replace(ev.entitlement_value,'_',':::') like 'Z:::%' and ev.entitlementtypekey=16