Skip to main content
6-Contributor
June 8, 2015
Question

Query the number of files in Windchill

  • June 8, 2015
  • 5 replies
  • 3265 views

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

MarcoTosin
21-Topaz I
June 8, 2015

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
RussC6-ContributorAuthor
6-Contributor
June 8, 2015

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

MarcoTosin
21-Topaz I
June 8, 2015

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