Skip to main content
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

 

 

 

 

 

1-Visitor
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

 

 

 

 

5 replies

1-Visitor
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

 

 

 

 

Apr 18, 2023 1:10 PM UTC

Thank you, this article was helpful for my needs.

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?

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