IBM Support

PH32894: GRID VIEWS WITH CUSTOM DEFAULT FILTERS EXPORT INCORRECT RESULTS

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

  • If a custom grid view is configured with a default filter that
    uses multiple values in the condition of the filter, the UI will
    display the correct list, but the export will return a different
    set of results.
    
    
    Steps to reproduce:
    Prerequisites:
    OpenPages 8.2 with standard test data
    
    Modify the default grid view so it uses a custom default filter:
    1.	Login to the Task UI as OpenPagesAdministrator
    2.	Click the gear->Solution Configuration->Views
    3.	Select the checkbox for Include system views
    4.	Filter by SOXIssue
    5.	Click on the view Sys-Grid-SOXIssue
    6.	Copy the JSON of the view to a text document
    7.	Return to the Views tab
    8.	Click Add New
    9.	Check the Use as default view? option
    10.	Set Object type to Issue, Name to Test-Grid-SOXIssue, and
    Type as Grid, then click Add
    11.	In the new View, click the JSON tab, then paste the view
    JSON saved earlier
    12.	Switch back to the Design tab, and click on the Default
    Filter link at the top of the design panel
    
    13.	Add a Filter Rule
    14.	Define the filter rule on the Impact field, selecting two
    values:
    
    15.	Click Done, then Done again
    16.	Click Publish to save the view
    
    
    
    Steps to Reproduce:
    1.	Login to the Task UI as OpenPagesAdministrator
    2.	Open hamburger->Remediation->Issues
    3.	The grid view should appear empty, as the default filter is
    applied and will not include any records
    4.	Click the export button
    5.	Open the exported spreadsheet, note that many records are
    included:
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * OpenPages Users                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * GRID VIEWS WITH CUSTOM DEFAULT FILTERS EXPORT INCORRECT      *
    * RESULTS                                                      *
    ****************************************************************
    * 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

  • The default filter is stored with the view. The UI just passes a
    flag as to whether or not the default filter is enabled. Then,
    on the server, if the defaultFilter is not part of the query
    model, it sets it into the queryModel to be used later by
    setDefaultFilter.
    
    The problem is that this is not happening as part of the
    buildQueryDefinition code, which is used over and over, for all
    kinds of queries.  We corrected 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

    PH32894

  • 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-12-21

  • 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