IBM Support

PM50106: Query returns incorrect result set if child record .state (dot State) is set as displayed field

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • A result set of a query based Defect which displays a state
    field (EnhancementRequest.State) of the child record returns
    ONLY records with child records linked to parent. Below is how
    this can be reproduced.
    
    1-- Use SAMPL database of an out of the box Enterprise schema.
    2-- Create a new field on Defect record called
    'EnhancementRequest' TYPE reference to Enhancement Request
    record type
    3-- From the Defect Based form drag and drop a Combo control box
    and set EnhancementRequest as Field Name
    4-- Check in schema and upgrade database
    5-- Open ClearQuest Native client and connect to the above
    repository
    6-- Run 'All Defects' query and modify a record from the list of
    result set by adding a child record
    7-- Edit the query by adding EnhancementRequest.State from the
    'Display editor'
    8-- Re-run the query
    
    Result:- The result set should ONLY display records which have
    EnhancementRequest.State
    

Local fix

Problem summary

  • If a ClearQuest child record has a reference field to a stateful
     parent record, queries run against the child record type will
    return the incorrect result set if the parent reference.state
    (dot State) is set as a displayed field.  Child records whose
    parent reference field are null are not displayed in the query
    result set.
    

Problem conclusion

  • A fix is available in ClearQuest 8.0.1.1.
    
    ClearQuest child records that do not have parent reference field
    now display in the result set.  In order to receive this fix,
    users must upgrade their ClearQuest Databases to Feature Level
    8.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM50106

  • Reported component name

    CLEARQUEST WIN

  • Reported component ID

    5724G3600

  • Reported release

    712

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2011-10-14

  • Closed date

    2013-10-07

  • Last modified date

    2017-07-06

  • 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

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

Document Information

Modified date:
08 September 2021