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

Last updated on JANUARY 24, 2024

Applies to:

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

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