IBM Support

Query returns incorrect result set if Childrecord.State is added as display field



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.

Diagnosing The Problem

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 the new field to the Defect_Base form
3-- Check-in the schema and upgrade the database
4-- Open ClearQuest Native or cqweb client and connect to the database
5-- Submit some EnhancementRequest records
6-- Add references to EnhancementRequests on a few Defect records
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

Resolving The Problem

If you have already upgraded to Feature Level 9 and are experiencing this problem, please contact support for a simple SQL command to fix the issue permanently. Upgrading to future Feature Levels, when available, will address this issue without the SQL fix.

[{"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Web Java Client","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":";9.0.1;;;;;;;;;;;;","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
01 August 2018