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.
01 August 2018