SetSearchExpr and special characters
(Doc ID 485520.1)
Last updated on FEBRUARY 25, 2019
Applies to:Siebel Tools - Version 126.96.36.199 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?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document