IBM Support

PH15951: SORTING RESULT SET OF AN UNSAVED EDITED QUERY GIVES INCORRECT RESULTS IN CLEARQUEST WEB 9.0.1.7

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • A user changes and executes an existing query. After this, the
    user clicks on a column to sort all query results in the result
    set window. The result set of the sorted result is based on the
    saved query and not on the current changes in the open query
    window. This happens when the sorting method is set to Entire
    Result Set.
    
    This issue is seen only in ClearQuest web 9.0.1.7 and not in
    previous versions.
    
    Steps to Reproduce
    
    Login with a user account to ClearQuest web.
    Go to Preferences -> Result Set -> Sorting Method -> Change to,
    Entire Result set.
    Open an Existing Query.
    In the Result Set Window, edit the query and add a new field.
    Run the Result set without saving the query.
    This will display the expected output in the Result Set.
    Sort the query results based on a column and the changes made to
    the query disappears and result set goes back to the saved query
    state.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ClearQuest                                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * If a ClearQuest Web user edits an existing query and clicks  *
    * on a column to sort all query results in the result          *
    * set window, the result set of the sorted result is based on  *
    * the saved query and not on the current changes in the opened *
    * query window.                                                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • A fix is available 9.0.1.11 and 9.0.2.3.
    If a ClearQuest Web user edits an existing query and clicks on a
    column to sort all query results in the result
    set window, the result set now displays correctly.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH15951

  • Reported component name

    CLEARQUEST WIN

  • Reported component ID

    5724G3600

  • Reported release

    901

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-08-22

  • Closed date

    2021-01-11

  • Last modified date

    2021-01-11

  • 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

    CLEARQUEST WIN

  • Fixed component ID

    5724G3600

Applicable component levels

  • R901 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"901","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
28 April 2022