cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X

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

towen
1-Visitor

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

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

1 REPLY 1
towen
1-Visitor
(To: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


Announcements


Top Tags