cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more! X

Query the number of files in Windchill

RussC
5-Regular Member

Query the number of files in Windchill

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.

5 REPLIES 5
Marco_Tosin
21-Topaz I
(To:RussC)

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

Marco
RussC
5-Regular Member
(To:Marco_Tosin)

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

Marco_Tosin
21-Topaz I
(To:RussC)

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

Marco
RussC
5-Regular Member
(To:Marco_Tosin)

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.SearchCriteria.JPG

Marco_Tosin
21-Topaz I
(To:RussC)

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.

Marco
Announcements


Top Tags