Skip to main content
B
BriGuy12-Amethyst
12-Amethyst
July 11, 2018
Question

Query Builder - Looking for help to add Version and State to query build report

  • July 11, 2018
  • 1 reply
  • 2724 views

I'm trying to export a list of all our drawings in Winchill with their respective Version and State listed. I stumbled across this link: https://www.ptc.com/en/support/article?n=CS237391 which shows how to set up a query build report.  By changing the NOT IN to IN in Condition 1, I was able to export the report showing all of our drawing part numbers with the .drw extension.

 

Can anyone help me as to how to add to this to display the Version (rev) and State for each drawing in the report??  When I do a standard search for .drw I can export with all the info but we have over 15,000 drawings and that exceeds the search limit.

 

 

1 reply

Marco Tosin
21-Topaz I
Marco Tosin21-Topaz I
21-Topaz I
July 12, 2018

Have you already seen this document?

https://community.ptc.com/t5/Windchill-Questions/Resource-for-reporting/td-p/448738

 

There is a section with query builder reports for EPMDocuments.

 

At the beginning of the document there is also a link to some old PTC presentations that could help you in building reports.

 

 

Marco
B
BriGuy12-AmethystAuthor
12-Amethyst
July 12, 2018

Thanks for the references Marco.  I almost have it.  I got my list to show the drawing number Name, State and Version. However, now it shows all the different versions ever created for the drawings and each state for that version. Trying to figure out how to display only the most current version.

Marco Tosin
21-Topaz I
Marco Tosin21-Topaz I
21-Topaz I
July 12, 2018

https://www.ptc.com/it/support/article?n=CS33305

 

Marco
Terms & ConditionsCookie settingsAccessibility statement