Welcome to the Jazz Community Forum
CQ Import Wizard and CQ REFRENCE_LIST fields

I'm trying to use the CQ Import Wizard on CQ records, such as defects, which have fields defined in the schema as REFERENCE_LIST. This is problematic in that any query which selects these fields as a display field can generate multiple instances of the same defect in the result set. Obviously this causes the importer to generate multiple RTC work items which isn't our desired result.
Has anyone worked around this issue or can provide some suggestions on how to import CQ records which have fields defined as lists so as to generate a single RTC work item which attribute fields which will contain these listed values? What would you even map these reference_list fields to in the RTC process template?
Has anyone worked around this issue or can provide some suggestions on how to import CQ records which have fields defined as lists so as to generate a single RTC work item which attribute fields which will contain these listed values? What would you even map these reference_list fields to in the RTC process template?
2 answers

Tom,
I had to do some intermediate scripting work to generate a consumable import, but there may be other methods.
There is no notion of a reference list either as you have already figured out, if you are going to bring this across it could be captured using the standard RTC link types so using something like related or parent/child to meet your needs.
-Sean
I had to do some intermediate scripting work to generate a consumable import, but there may be other methods.
There is no notion of a reference list either as you have already figured out, if you are going to bring this across it could be captured using the standard RTC link types so using something like related or parent/child to meet your needs.
-Sean