IBM Support

PM20749: Export Query Results duplicates rows if list view filter field is included in display fields.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • CQ 7.1.1 Eclipse client shows a problem on the Export Query
    Results functionality
    A query with filter on a list view will only return rows in the
    result set according to the filter values.
    The returned rows will be duplicated on the result set export if
    the records contain other values in that list view.
    
    It can easily be reproduced on a DefectTracking sample db, rcp
    client:
    - Pick 4 defect records and set the customer field to Anne + a
    few other customers.
    - Create a new query on defects with a filter on customer=Anne
    Johnson
    - Display fields id, Headline, Customer.
    - Run query, it returns the 4 defects.
    - Run Export Query Results.
    - In the exported file the resulting records are duplicated
    according to the number of customers in their lists.
    
    It makes no difference whether the filter is dynamic or static.
    Tested .txt and .xml format, no difference.
    Workaround: Windows client does not duplicate the rows on grid
    export.
    
    Reproduced in in 7.1.1.DF091201A and 7.1.1.02.00_2010B.D100611.
    Tested on 7.0.1.7 and 7.1.0 where the defect does not exist.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The exported query results incorrectly contained a record
    for each unique combination of display fields for each ID
    specified.
    

Problem conclusion

  • A fix is available in ClearQuest 7.1.1.08, 7.1.2.05 and
    8.0.0.01.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM20749

  • Reported component name

    CLEARQUEST WIN

  • Reported component ID

    5724G3600

  • Reported release

    711

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-08-18

  • Closed date

    2011-12-16

  • Last modified date

    2011-12-16

  • 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

  • R711 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.1.1","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
16 December 2011