IBM Support

PI84142: QUERY RETURNS INCORRECT RESULT SET IF CHILDRECORD.STATE IS ADDEDAS DISPLAY FIELD

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • A query on parent records with child references returns
    incomplete results when the child record State field is added as
    a display field.
    Parents that have no child reference (i.e. where Child.State is
    empty) are not returned.
    
    Reproduction Steps in a DefectTracking schema with
    EnhancementRequest package applied.
    
    1-- Create a new field on the Defect record called
    'EnhancementRequest' TYPE Reference to EnhancementRequest record
    type
    2-- Add a Combo Box control on the Defect Base form and set
    EnhancementRequest as Field Name
    3-- Check in schema and upgrade database
    4-- Open ClearQuest Native client and connect to the above
    repository
    5-- Submit EnhancementRequest record(s)
    6-- Add a reference to an EnhancementRequest on a Defect record
    7-- Modify the 'All Defects' query by adding
    EnhancementRequest.State as display field
    8-- Run the query
    
    Result:- The result set ONLY returns records that have an
    EnhancementRequest.State value
    
    This behaviour was fixed for Feature Level 8 schemas but appears
    again with Feature Level 9.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ClearQuest                                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Adding the State field of a child record to a query causes   *
    * the result set to not include any records where the child    *
    * reference field does not have a value.                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • A fix is available in ClearQuest 9.0.0.5 and 9.0.1.1
    The issue has been fixed so that the result set includes records
    with an empty child reference field.
    
    Upgrading to Feature Level 9 with this APAR fix will not cause
    the problem described to occur.
    Upgrading to Feature Levels newer than 9, when available, will
    also address this issue even if it is being encountered pre-FL8
    or in databases that were impacted that had upgraded to FL9
    previously.
    If currently at Feature Level 9 and impacted, and you do not
    wish to upgrade to a newer Feature Level when available, you may
    contact Support for a permanent fix involving a SQL statement
    for FL9.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI84142

  • Reported component name

    CLEARQUEST WIN

  • Reported component ID

    5724G3600

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-07-07

  • Closed date

    2017-09-14

  • Last modified date

    2017-09-14

  • 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

  • R801 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"801","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
18 October 2021