cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X

Looking for table with versionDisplayIdentifier and IterationDisplayIdentifier

ShaylynJoy
1-Visitor

Looking for table with versionDisplayIdentifier and IterationDisplayIdentifier


Hi everyone,


We have a QML Report Manager report that shows the exact Version and Iteration of a Part that was Released in an ECN Process. We made this because the Windchill interface always reports the latest Iteration even if it was modified after the ECN Release.


The QML Report does this by showing:


versionDisplayIdentifier


IterationDisplayIdentifier


From the WTPart table. What I am trying to do is replicate the same report in a sql statement but these columns don't exist, only versionida2versioninfo and iterationida2iterationinfo from wtpart. This brings back all iterations instead of the iteration that was Released in the ECN.


I was wondering if anyone had a similar problem or knew of a way to do this. PTC response was that "The Iteration Display Identifier is derived and not available as a column in the database." But I feel like there should be a way to do this. At least I hope so...


Thank you!


- Shaylyn


1 REPLY 1

It's probably too late by now, but the VALUEA2B2VERSIONINFO column is the version.iteration of the part.

Announcements


Top Tags