OpTypeEnum.LIKE Is Not Working As Expected (Doc ID 2384090.1)

Last updated on JULY 07, 2020

Applies to:

Symptoms

OpTypeEnum.LIKE does not appear to be working as expected.  It appears to only find exact matches, instead of "LIKE" matches.

(Class com.fatwire.assetapi.query - Enum OpTypeEnum

     https://docs.oracle.com/cd/E29542_01/apirefs.1111/e39356/com/fatwire/assetapi/query/OpTypeEnum.html

Used in the following call:

     Condition c = ConditionFactory.createCondition( "Title", OpTypeEnum.LIKE, searchValue);


For example, the following results are observed...

  Attr value=Winter ; Search Value=Winter ; Actual Result = true ; Expected Result = true
  Attr value=WildWinter ; Search Value=Winter ; Actual Result = false ; Expected Result = true
  Attr value=Winter Wonderland ; Search Value=Winter ; Actual Result = false ;Expected Result = true
  Attr value=Winter & Skiing ; Search Value=Winter ; Actual Result = false ; Expected Result = true

Changes

Cause

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