My Oracle Support Banner

Basic Search with AND Operator Returns Unexpected Result When ‘Enable Include Attachments Text’ Is Checked On (Doc ID 2677809.1)

Last updated on MARCH 15, 2021

Applies to:

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

Symptoms

Actual Behavior
When enable Include Attachments Text : checked, the Basic search will not return search result with AND criteria and return unexpected results.

Example :
Item : Document
Name/Number/Desc  : Contains Phrase : <Search Character> (Include Attachments Text : check)   AND
Cascade List Attribute : In : <Search List Value>

Fact
Basic Search for Item (Document) Subclass with following search criteria will return expected search result with AND criteria.

Example :
Item : Document
Name/Number/Desc  : Contains Phrase : <Search Character> (Include Attachments Text : uncheck)   AND
Cascade List Attribute : In : <Search List Value>

Steps
The issue can be reproduced at will with the following steps:
1. Login to Java Client in admin user
2. Go to Data Settings > Classes > Documents > User Interface Tabs > Page Two
3. Set Visible : Yes for Attribute : MultiList02 and assign Cascade List : testCascade01 having 2 list value : A, B
4. Login to Web Client in admin user
5. Create 2 new documents

D00008
D00009

with Page Two.MultiList02 field set with value : A

6. Run Basic Search with below criteria

Items : Document

Name/Number/Desc : Contains Phrase : D       (Include Attachments Text : null)    AND
MultiList02      : Contains Any : A

7. Result

Number      Lifecycle Phase    Document Type
--------------------------------------------
D00008      Preliminary         Document
D00009      Preliminary         Document

8. Run Basic Search with below criteria

Items : Document

Name/Number/Desc : Contains Phrase : D       (Include Attachments Text : check)   AND
MultiList02      : Contains Any : A

9. Result

Number      Lifecycle Phase    Document Type
--------------------------------------------
D00001      Preliminary         Document
D00003      Preliminary         Document
D00004      Preliminary         Document
D00005      Preliminary         Document
D00006      Preliminary         Document  
D00008      Preliminary         Document
D00009      Preliminary         Document

Cause

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
Symptoms
Cause
Solution
References


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