Query Builder - Reporting on CAD Drawings and related parts, assemblies and formats

[towen]

Hello,

I am attempting to create a report using the Query Builder that outputs a table listing all drawings in a certain folder and, importantly, the part or assembly that it references, along with the format used as well.

I'm not sure how to create the join/criteria that can output these relations.

The CAD data I am working with is part of a subtype of the default "EPMDocument", and contains soft attributes (parameters) that I also require to output in the report. I'm unsure if this will be a problem, but I would appreciate any explanations on information provided so I can adapt it to this subtype as necessary.

Any help would be greatly appreciated!

Thank you,

Tristan

[towen]

I have been looking around further, and identified the link required:

EPM Document Reference Link.Reference Type = Drawing

(From: http://communities.ptc.com/message/187608#187608)

However, I am still struggling to create the query correctly. Could anyone please advise me in the best way to construct the query to get an output similar to:

Part Name, Part Number, Part Filename, Drawing Name, Drawing Number, Drawing Filename

Thank you,

Tristan