SetSearchExpr and special characters

(Doc ID 485520.1)

Last updated on SEPTEMBER 21, 2017

Applies to:

Siebel Tools - Version 7.5.3.9 SIA [16194] and later
Oracle Solaris on SPARC (64-bit)

Goal

The following search expression is used to query LOV BC for entries in eScript:

var srchExpr;
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?


Solution

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