SetSearchExpr and special characters
Last updated on SEPTEMBER 21, 2017
Applies to:Siebel Tools - Version 184.108.40.206 SIA  and later
Oracle Solaris on SPARC (64-bit)
The following search expression is used to query LOV BC for entries in eScript:
srchExpr = "[Active] = 'Y' AND [Type]= '" +propType+ "' AND [Value] = '" +ioFieldValue+ "'";
The SetSearchExpr fails when there are special chars in ioFildValue like (, ), ', [
How to form the srchExpr when the ioFieldValue contains specifical characters?
(There is no problem with the srchExpr when there are no special characrters).
Let's say ioFieldValue is "Women's Tennis". Do we need to replace the single quote char in the string too?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms