Query the number of files in Windchill

[RussC]

I am looking to update some models using a tool which charges per part, so I need to know how many files I have in my Windchill PDMLink 10.2 database with the file extension ".prt".  So far, we have tried increasing the number of results which will show in our search window to 1,000,000.  Then we simply entered an advanced search for all .prt files.  For some reason we only get 4000 hits but we know we have many more than that.  I was wondering if there is a different way to perform this query in Windchill.

[Marco_Tosin]

Russ,

use a query builder instead of a search, or a SQL script.

About using query builder, take a look at this document Resource for reporting

In it you can find a section about WTPart, with some report already done.

Marco

[RussC]

Thanks.  I downloaded the QML file for the exact report that I need.  How do I run it?

[Marco_Tosin]

You have to import your query builder in Windchill, using report manager.

In my document there is a link at this article from PTC's support

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS113617&lang=en

[RussC]

Thanks, that was really simple.  The only thing is, the list of items contains the same part number many times leading to a list of over 65,000 items.  Is there a way to modify the query so only the latest iteration shows up in the results?  I attached a screenshot of the query I ran.

[Marco_Tosin]

In the same document, you can find this attachment.

https://www.ptcusercommunity.com/servlet/JiveServlet/download/6348-56-73173/_Reporting6.2.pptx

Before doing some other works on your report, I suggest you to read it.

It's quite old and have more than 100 slides, but it's the best document PTC ever wrote about reporting.