HDR: "OR" Criteria Is Only Bringing Back Results For The First Criteria And Ignoring The Second Criteria (Doc ID 2221952.1)

Last updated on MAY 07, 2017

Applies to:

Oracle Healthcare Data Repository - Version 7.0.1 and later
Information in this document applies to any platform.

Symptoms

On : 7.0.1 version, Data Model

ACTUAL BEHAVIOR
---------------
RIM Query is only bringing back results for the first criteria and ignoring the second criteria. It is happening only in cases where the criteria's have 'LIKE' search operator.

EXPECTED BEHAVIOR
-----------------------
Expecting the application to bring back result based on first and second criteria.

Example" 

ActAttributeCriteria acdmetadataCriteria = qcf.newActAttributeCriteria();
acdmetadataCriteria.setValue(SearchOperator.LIKE, dtf.newST("%docTypeCode=" +
"100.16685" + "%"));
ActAttributeCriteria phsmetadataCriteria = qcf.newActAttributeCriteria();
phsmetadataCriteria.setValue(SearchOperator.LIKE, dtf.newST("%docTypeCode=" +
"100.16671" + "%"));
...

Criteria[] criteria = { phsmetadataCriteria, acdmetadataCriteria };

ActAttributeCriteria metadataCriteria = (ActAttributeCriteria)
qcf.or(criteria);

This issue is occurring only when setting 'LIKE' operator on both ActAttributeCriteria.

NOTE: There is also an issue where OR() operator always times out after patch 7.0.1.6

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