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? |
2 answers
|
Any takers on this topic? Has anyone tried the CQ Import Wizard and run into this scenario?
|
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 |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.