Document sub type object contains comma separated values from mapped WT part iterations

[ldutoit]

Hi, currently we map an attribute called PlannerNumber between Document sub type (called ISIR) and WT part. An ISIR object is associated to WT part.

The problem is that the ISIR PlannerNumber attribute value somehow contains all the WT part version values separated with "," characters. This is invaluable to us since we only want latest PlannerNumber in the ISIR document subtype.

For example: if WT part PlannerNumber attribute had the folowing values assigned in the iterations as follows:

WT PART Number                         Version                      PlannerNumber

BN123456                                        A.1                                   100

BN123456                                        A.2                                   200

BN123456                                        A.3(Latest)                       300

Then the Latest version of attached ISIR object will have PlannerNumber field as "100,200,300"

We would like the ISIR object associated to the BN123456 WT part to contain only the latest value eg. "300"