ACCEPTED SOLUTION
Accepted Solutions
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.
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 -
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.
