IBM Support

JR49131: REST API QUERY FILTER DOES NOT DIFFERENTIATE BETWEEN LIKE AND NOT LIKE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When executing saved searches or queries using REST API, if
    filter conditions are used, the query does not return correctly
    for NOT LIKE conditions. It is treated as LIKE.
    

Local fix

  • No local fix
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  IBM BPM Express, Standard and Advanced      *
    *                  Edition.                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: Executing saved search queries using    *
    *                      REST API with filter 'NOT LIKE' does    *
    *                      not take effect.                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Users can execute saved searches using REST API Tester(Search
    API  ¢â€ â€™ Execute Query) or by invoking the following URL :
    http://localhost:9080/rest/bpm/wle/v1/tasks/query/<saved_search>
    ?queryFilter=<filter_expression>
    A filter can be used to exclude unnecessary values that are
    not required by the user.  The following filters are available
    for filtering: CONTAINS, STARTS WITH, ENDS WITH, LIKE , NOT
    LIKE .  A problem occurs when using the filter 'NOT LIKE' as
    it will return all values that will contain the value
    specified in the filter.  Meaning, the query will filter the
    response as if it was using the filter 'LIKE'.  Therefore, the
    results of the query are incorrect.
    

Problem conclusion

  • A fix has been developed to properly filter the results
    according to the 'NOT LIKE' expression and will return results
    that do not contain the specified value.
    An interim fix for 8.5.0.0 is available. On Fix Central
    (http://www.ibm.com/support/fixcentral), search for JR49131.
    After you select the product group, product, installed
    version, and platform, click Continue and then select APAR or
    SPR, enter JR49131, and click Continue. When downloading fix
    packages, ensure that you also download the readme file for
    each fix. Review each readme file for additional installation
    instructions and information about the fix.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR49131

  • Reported component name

    BPM STANDARD

  • Reported component ID

    5725C9500

  • Reported release

    850

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-01-23

  • Closed date

    2014-03-20

  • Last modified date

    2014-03-20

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    BPM STANDARD

  • Fixed component ID

    5725C9500

Applicable component levels

  • R800 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
20 March 2014