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
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
It's probably too late by now, but the VALUEA2B2VERSIONINFO column is the version.iteration of the part.