Report Query to get Reference By Data

[ZC_10909252]

Version: Windchill 12.1

Use Case: I am trying to generate a report for all the drawings that reference a part/assembly in windchill.

Description:

I have attached the qml I used which seems to generate a report with multiples of the same drawing reference for a given part instead of just one (pictured below). I thought setting the criteria for Cad Document.Latest Iteration equal to 1 would return the referenced by data for only the latest iteration.

 

[Marco_Tosin]

It is not enough to select last iteration because this selection extracts ALL the last iterations of each individual Revision.

To select only the very last you have to use a fairly complicated system that is explained in this article.

Report of the latest version of all drawings at any State

You can start with the QML file attached to above article and then add the tables for references as explained in this other

How to create a Query Builder Report to get all CAD references of a Drawing in Windchill PDMLink

[anursingh]

Hi @ZC_10909252,

I wanted to see if you got the help you needed.

If so, please mark the appropriate reply as the Accepted Solution. It will help other members who may have the same question.
Please note that industry experts also review the replies and may eventually accept one of them as solution on your behalf.
Of course, if you have more to share on your issue, please pursue the conversation. 

Thanks,
Anurag