Skip to main content
I
iwebb1-Visitor
1-Visitor
July 10, 2013
Solved

Report Manager: How to write a WTPart Where Used Report

  • July 10, 2013
  • 2 replies
  • 4364 views

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

    Best answer by MikeLockwood

    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

    2 replies

    J
    jzupfer1-Visitor
    1-Visitor
    July 10, 2013

    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 -

    M
    MikeLockwood22-Sapphire IAnswer
    22-Sapphire I
    July 10, 2013

    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

    V
    vkadu5-Regular Member
    5-Regular Member
    September 30, 2015

    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

    Terms & ConditionsAccessibility statement