Skip to main content
Marco Tosin
21-Topaz I
Marco Tosin21-Topaz I
21-Topaz I
October 16, 2015
Solved

Report to list WTParts of particular view

  • October 16, 2015
  • 3 replies
  • 3405 views

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.

Best answer by Marco Tosin

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).

OR_criteria.PNG

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.

Sub-select_from.PNG

Sub-select_Select.PNG

Sub-select_Criteria.PNG

3 replies

Marco Tosin
21-Topaz I
Marco Tosin21-Topaz IAuthor
21-Topaz I
October 22, 2015

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?

Marco
Marco Tosin
21-Topaz I
Marco Tosin21-Topaz IAuthor
21-Topaz I
October 27, 2015

I've opened a case with support, but haven't still got an answer.

Anyone has a suggestion?

Marco
Marco Tosin
21-Topaz I
Marco Tosin21-Topaz IAuthorAnswer
21-Topaz I
October 29, 2015

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).

OR_criteria.PNG

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.

Sub-select_from.PNG

Sub-select_Select.PNG

Sub-select_Criteria.PNG

Marco
R
rleir17-Peridot
17-Peridot
April 13, 2021

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 

Marco Tosin
21-Topaz I
Marco Tosin21-Topaz IAuthor
21-Topaz I
April 13, 2021

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.

 

 

Marco
Terms & ConditionsAccessibility statement