We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

how to handle comma in a runtime variable when passed to a query in dynamic attribute.

VamsheeVazza
New Contributor
New Contributor

Hi 
I have a case where we send a runtime parameter into a query which will decide the values that will be shown in a dynamic attribute dropdown

using below query
select ev.entitlementID as ID from entitlement_values ev join entitlement_types et on et.ENTITLEMENTTYPEKEY = ev.ENTITLEMENTTYPEKEY join endpoints ep on ep.ENDPOINTKEY = et.ENDPOINTKEY where et.ENTITLEMENTNAME = "WorkLocation_CSP" and ep.endpointname = "Customer Service Platform (CSP)" and ev.entitlement_value = ${Service_Location}

 

this works fine when the value is straight forward. but it is not pulling any values when there is comma in the ${Service_Location} parameter.

also tried to replace the comma but no use

select ev.entitlementID as ID from entitlement_values ev join entitlement_types et on et.ENTITLEMENTTYPEKEY = ev.ENTITLEMENTTYPEKEY join endpoints ep on ep.ENDPOINTKEY = et.ENDPOINTKEY where et.ENTITLEMENTNAME = "WorkLocation_CSP" and ep.endpointname = "Customer Service Platform (CSP)" and ev.entitlement_value = replace(${Service_Location}, ",", "")

 

please suggest how to handle this case.

2 REPLIES 2

sk
All-Star
All-Star

@VamsheeVazza Did you try like option?

 ev.entitlement_value like ${Service_Location} or 

 ev.entitlement_value like '${Service_Location}'

 

 


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

rushikeshvartak
All-Star
All-Star

select ev.entitlementID as ID from entitlement_values ev join entitlement_types et on et.ENTITLEMENTTYPEKEY = ev.ENTITLEMENTTYPEKEY join endpoints ep on ep.ENDPOINTKEY = et.ENDPOINTKEY where et.ENTITLEMENTNAME = "WorkLocation_CSP" and ep.endpointname = "Customer Service Platform (CSP)" and ev.entitlement_value ='${Service_Location.replace(",","', '")}'


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