Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X
Hi all,
I'm trying to build a report to catch list of WTParts of particular view.
I've started working on the report attached in this article https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS208737
As usual, without using a sub selection, you can see all revisions.
Can someone help me to build it?
P.S.: SQL query it's not an answer for this specific case.
Solved! Go to Solution.
I've got the solution from Marco Ferrari.
First of all it's necessary to add an OR condition in criteria, and relative sub-select, for each view (7 in my case).
Then in sub-select you must add criteria to have the latest for each view, in the same way that you work to get the latest version of a WTPart.
I did some work to get my report, but without success (what I was expecting were 4 objects).
.
I followed this two ways:
The result (7 objects) was the same I got doing a search in Windchill GUI (latest iteration of every version for every view).
Then I followed what is described in this presentation query builder Latest Revision to get only the very latest, but again without success.
The result (2 objects) gave me only the latest version of plant views, but it wasn't correct because Design and Mfg views were missing.
Anyone has some further ideas?
I've opened a case with support, but haven't still got an answer.
Anyone has a suggestion?
I've got the solution from Marco Ferrari.
First of all it's necessary to add an OR condition in criteria, and relative sub-select, for each view (7 in my case).
Then in sub-select you must add criteria to have the latest for each view, in the same way that you work to get the latest version of a WTPart.
Hi Marco
Newer versions of WC do not have the Java screens that you show, they have a Javascript GUI which looks different. Would you be able to show how to get the latest revision using the newer screens please?
thanks -- Rick
Hi Rick,
GUI for Report Builder in newer versions of Windchill has changed, but you can build the sub-selection in the same way as the old one.