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

Report Manager: How to write a WTPart Where Used Report

SOLVED
Highlighted
Newbie

Report Manager: How to write a WTPart Where Used Report

I need to be able to do a single level 'Where Used' on all the WTParts in a Library (there are 1000's)

I guess writing a report is the way to do this (I am open to other suggestions...)

But I have no idea where to start, and cannot find an example to work from...

I am using Windchill 10.1.

Anyone help please ?

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Report Manager: How to write a WTPart Where Used Report

Below is the general approach needed for this sort of thing - although you quickly find that query builder doesn't work well yet with structures.

The challenge on this one is feeding the list of Parts in the Library into the report. Probably have to do in two phases: a) Get all the Parts in that Library as a list, and arrange as comma-separated b) Feed that list into the Report, using "IN" for the part Number criteria (of the Child part). note: Without an outer join, any Parts which are not used will not be included in the output. May or may not want this.

tricky but good stuff

I've spent a zillion hours on getting query builder reports to do magic - there seems to be absolutely nothing beyond the very fundamentals ever published by PTC on it. The tutorial is fine, but only gets you thru "preschool" level for such - after going thru it you're only prepared for the absolute most basic reports.

Types.png

joins.png

select.png

3 REPLIES 3

Re: Report Manager: How to write a WTPart Where Used Report

Hello Ian,

I don't have any alternative suggestions regarding the information you want to generate, but I'm responding to refer you to the Query Builder tutorial available in the Windchill Help Center; it provides a step-by-step procedure for building a report. If you haven't seen this tutorial, you may find it helpful:

http://www.ptc.com/cs/help/windchill_hc/wc101_hc/index.jspx?id=QBTutorialRef&action=show

(The Query Builder help and tutorial are also available when you click the help link on the Query Builder dialog that is presented when you select Report Management from the Site utilities page.)

If you have any feedback regarding this documentation, I'd appreciate your input!

Jane

Jane Zupfer
VP, Enterprise Products Publications
T 763.957.8299 E -

Re: Report Manager: How to write a WTPart Where Used Report

Below is the general approach needed for this sort of thing - although you quickly find that query builder doesn't work well yet with structures.

The challenge on this one is feeding the list of Parts in the Library into the report. Probably have to do in two phases: a) Get all the Parts in that Library as a list, and arrange as comma-separated b) Feed that list into the Report, using "IN" for the part Number criteria (of the Child part). note: Without an outer join, any Parts which are not used will not be included in the output. May or may not want this.

tricky but good stuff

I've spent a zillion hours on getting query builder reports to do magic - there seems to be absolutely nothing beyond the very fundamentals ever published by PTC on it. The tutorial is fine, but only gets you thru "preschool" level for such - after going thru it you're only prepared for the absolute most basic reports.

Types.png

joins.png

select.png

Re: Report Manager: How to write a WTPart Where Used Report

Please refer to the below link of an article for listing the Where Used for an EPM Document in Windchill PDMLink 10.1
https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS103435