IBM Support

PH31091: ORDER BY DESCRIPTION NOT WORKING WELL IN GRID RELATIONSHIP CARD

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • Description:
    When the description field has slashes (/) in a very specific
    way, the order by description feature seems to ignore the first
    part of the text.
    
    Example:
    When you have the following business entity ? description:
    BE01 > SubBE01 > A - /BE01/SubBE01/A
    BE01 > SubBE01 > B - /BE01/SubBE01/B
    BE01 > SubBE01 > C - /BE01/SubBE01/C
    BE01 > SubBE01 > D - /BE01/SubBE01/D
    BE01 > SubBE01 > E - /BE01/SubBE01/E
    BE01 > SubBE01 > F - /BE01/SubBE01/F
    BE01 > SubBE01 > G - /BE01/SubBE01/G
    BE01 > SubBE01 > H - /BE01/SubBE01/H
    
    When you use the order by description feature in a grid
    relationship card, the business entities are not listed
    sequentially but based only on the last part, A, B, C, etc?
    
    Workaround:
    Not exactly a workaround but after you search by BE01 in this
    example, the order by description works well:
    
    Prerequisites:
    A)	OpenPages with solutions installed
    
    B)	Import the testing data which is in the BEFastMap.xls file
    1.	Log in to OpenPages as administrator
    2.	Click the cogwheel icon > FastMap > FastMap Import
    3.	Click Choose File, select BEFastMap.xls file and then click
    Open
    4.	Click Import Data and after the validation finish
    successfully click Import Data again
    5.	Close the window
    
    Steps to Reproduce:
    1.	Log in to OpenPages
    2.	Click the navigation menu > Organization > Business Entities
    3.	Click the Add New button
    4.	Under Primary Business Entity section at the bottom, click
    Select Primary Business Entity
    5.	In the popped-up window, check the list is ordered by Name
    6.	Click the Description column to order by Description
    7.	Notice the A to H business entities are not listed
    sequentially as it should be
    
    Expected Results:
    Order by description should work well no matter if the text has
    slashes or not
    
    Actual Results:
    The order is affected wrongly by the slashes
    
    Error Message:
    Not found
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * OpenPages Users                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * ORDER BY DESCRIPTION NOT WORKING WELL IN GRID RELATIONSHIP   *
    * CARD                                                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Customers should download OpenPages with Watson 8.2 Fix Pack *
    * 2 (8.2.0.2). See the following document for details on       *
    * obtaining OpenPages 8.2.0.2:                                 *
    * https://www.ibm.com/support/pages/openpages-watson-82-fix-pa *
    * ck-2                                                         *
    ****************************************************************
    

Problem conclusion

  • Sorting was not working correctly in ObjectPicker. The sorting
    object was not initialized, causing the sort to be Carbon's
    native sort on just the currently loaded page.  We fixed this.
    
    Customers should download OpenPages with Watson 8.2 Fix Pack 2
    (8.2.0.2). See the following document for details on obtaining
    OpenPages 8.2.0.2:
    https://www.ibm.com/support/pages/openpages-watson-82-fix-pack-2
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH31091

  • Reported component name

    OPENPAGES GRC

  • Reported component ID

    5725D5100

  • Reported release

    820

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-10-29

  • Closed date

    2021-04-02

  • Last modified date

    2021-04-02

  • 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

    OPENPAGES GRC

  • Fixed component ID

    5725D5100

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSFUEU","label":"IBM OpenPages with Watson"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"820"}]

Document Information

Modified date:
03 April 2021