Query Builder report WIndchill 12

[CG_10645626]

Hi all,

I would like to create a report to get these informations From WTPart and his related object (Drawing Association:Calculated)

      WTpart name

      Drawing name

      Drawing ID (used in the URL)

      Drawing Context Type (Library, Product...)

      Drawing Context Name

      Drawing Context ID (used in the URL)

Goal: for each part I want to create an URL to link the drawing in windchill from an excel file 

Do you thing is it possible ?

Thanks in advance

[Marco_Tosin · Accepted solution]

You can try to build your report from this article.

https://www.ptc.com/en/support/article/CS23768

[CG_10645626]

Thank you, this article was helpful for my needs.

[Greg75]

Hi - how did you modify the join to get the calculated link to drawings instead of the link to the model?

[HelesicPetr]

Hi @Greg75 

Join WTPart with CAD Model and CAD Model Join with Drawing

WTPart->BuildRule->CAD Document-> ReferenceLink->CAD Document

PetrH

[TDT]

Hi @CG_10645626,

Its possible to generate the report using Windchill QML Reporting functionality.

But to build the link we need to write the Java function and the same has to be triggered from QML Report