Skip to main content
4-Participant
Apr 12, 2023 1:18 PM UTC
Solved

Query Builder report WIndchill 12

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

 

 

 

 

 

MarcoTosin
21-Topaz II
Apr 12, 2023 1:33 PM UTC

You can try to build your report from this article.

 

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

 

 

 

 

Marco

5 replies

MarcoTosin
21-Topaz II
Apr 12, 2023 1:33 PM UTC

You can try to build your report from this article.

 

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

 

 

 

 

Translate
Marco
4-Participant
Apr 18, 2023 1:10 PM UTC

Thank you, this article was helpful for my needs.

Translate
4-Participant
May 31, 2023 8:43 AM UTC

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

Translate
18-Opal
Apr 13, 2023 9:23 AM UTC

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

Translate