Looking for table with versionDisplayIdentifier and IterationDisplayIdentifier
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:
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...