Simple Search Using Wildcard Is Not Working as Expected for Item Number With Space (Doc ID 1957126.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Agile PLM Framework - Version 9.3.3.0 and later
Information in this document applies to any platform.

Symptoms

Actual Behavior
Simple search using wildcard is not working as expected for item number with space.
For example, trying to search for item with number "9" at the 5th digit, but item with number "9" at the 5th digit after the space is searched

Expected Behavior
Can search only for the item with number "9" at the 5th digit

Steps
The issue can be reproduced at will with the following steps:
1. Login to Web Client
2. Create below items
10A563 00849
10A604 00859
10A699 00929     ---> This is the only item with number "9" at the 5th digit
10A689 00921

3. Run Simple Search with below stringļ¼š
????9*

4. See below items are returned:
10A563 00849
10A604 00859
10A699 00929


Instead of only returning the item with "9" at the 5th digit, it is returning item with "9" at the 5th digit after the space also.



Cause

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