Search On Simple Lists Type Does Not Recognize Parenthesis (Doc ID 2644958.1)

Last updated on MARCH 02, 2020

Applies to:

Symptoms

On : 9.3.6.0 version, Searches

Summary:

Search on simple  lists does not recognize parenthesis

Actual Behavior:

When trying to do a search for a list value in a search based multilist  and a search based list, if we input a parenthesis "()" into the search field, no records will be returned, even if the value contains a parenthesis in it. This is only happening on non-dynamic lists. Other search based dynamic lists we have configured in the system do not present this issue.

Expected Behavior :

Searches for values that have () should be returned. For example search value (AB) should be returned

Steps to Reproduce

The issue can be reproduced at will with the following steps:

Create a simple List

1- In Java Client go to Settings--> Data Settings--> Lists
2- Create a list call it for example : SimpleListType
3- Make sure to have under the general Information :
Name : SimpleListType
API Name : SimpleListType
Description : TestList
List Type : Simple
Display Type : Search

4- Under the "List" tab add these values so you can search for them later :
 (AB)
 (SimpleListType)
 ABC
 TEST(AA)

5- Now Go to Data Settings --> Classes--> Under Items select "Parts" --> User Interface Tabs--> page Two --> Attributes : Page Two --> Select "List 11 "--> Under visible select : "Yes" --> Under List select : "SimpleLisType"

6- Login to Agile WebClient and create a Part

7- Go to edit then scroll down to page 2 , in the "List 11" field search for example enter :  (AB)

click on the search button: Notice that it will not return (AB) , because since it has parenthesis ( that is the issue ) ! it will instead return the value ABC (which does not have a parenthesis) So values with parenthesis with not be returned for simple list searches

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
n/a

Cause

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