Unable To Perform Exact String Searches In Search By Field In List Applets (Doc ID 2145661.1)

Last updated on FEBRUARY 12, 2019

Applies to:

Symptoms

 In Siebel OpenUI, search in List applet is not able to perform exact match search instead is using a "like" match search.

Example:

Go to a list applet (Contacts for example) and create 2 contacts:

(LastName) (FirstName)
Administrator Siebel
Administrator Second Siebel

Go the the Applet search (using Query on the List Applet or using Query in Serch by Field on top of the List Applet).
Search for Last Name as Administrator: both results will be displayed - expected behavior
Search for Last Neme as "Administrator": both results will be displayed - unexpected behavior as using quotes should perform exact match search so onlyone contact should be displayed.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.