How can you create a back reference field in IBM® Rational® ClearQuest®?
A back reference field would be used to be able to not only see the child records of a parent record type, but also to be able to see the parent records that are associated to that child record type. For example, a back reference field would be used if a user would like to see which customers have experienced a specific defect and would also like to know all of the defects a certain customer has experienced.
- Log in to the Rational ClearQuest Designer and check out the schema.
- Create a field in the defect record type called "Related_customers". This is of type REFERENCE_LIST to the Customer record type.
- Next, add a back reference called "Related_defects". "Related_defects" will now be a read-only field that automatically gets created in the Customer stateless record type.
- Drag the "Related_customers" field onto the Defect record type form. This will create a list view box with 3 buttons (Add, New, and Remove).
- Now go into the Customer stateless record type. Drag "Related_defects" field onto the Customer record type form. Both of them are parent/child or list view type field properties. The related_customer field will have the Add, New, and Remove buttons, but the back referenced field (related_defects) on the customer form will not. This is because a user can add or create a new customer from the Defect record type, but cannot create a new defect from the Customer record type.
- In the Rational ClearQuest client, for example there are 2 customers: Sue and Joe. If no customer records exist in the database, add two test customers.
- Login to the user database (SAMPL in this example) and submit 5 defects.
- Submit defect SAMPL000001 - Assume that no one is experiencing this problem, so do not add Sue or Joe to the related_customers field.
- Submit defect SAMPL000002 - This was reported by Sue. Go to the related_customers field and "Add" Sue to the list.
- Submit defect SAMPL000003 - This is a known problem that both Joe and Sue have reported. Here, "Add" both Joe and Sue.
- Submit defect SAMPL000004 - This is a known problem that both Joe and Sue have reported. Here, "Add" both Joe and Sue again.
- Submit defect SAMPL000005 - This was reported by Joe. Go to the related_customers field and "Add" Joe to the list.
Run a query on the Customer record type. Looking at the customer record for Joe, SAMPL000003, SAMPL000004, and SAMPL000005 will be listed.
Note: It is not recommended to add a back reference field when creating a field that references its own record type. For example, creating a field "A" in the Defect record type that is of type REFERENCE_LIST to the Defect record type and then adding a back reference field to reference back to the Defect record type. This would cause a loop and often results in an out of range error. Back references should only be applied when using two different record types.
For more information on creating back references, see the topic: Linking records to create parent/child hierarchies in the ClearQuest 7.0.x information center.