Troubleshooting
Problem
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.
Was this topic helpful?
Document Information
Modified date:
01 August 2018
UID
swg22007390