Skip to main content
J
jasiek1-Visitor
1-Visitor
April 29, 2015
Question

Query builder to find unassociated CADs

  • April 29, 2015
  • 1 reply
  • 2428 views

Hi!

I'd like to find all CAD documents which are haven't associations with WTparts. I need to find which CREO *.prt and *.asm files are not associated with WTparts by any association (owner, contributing image etc.). I've found Document - CS190123 which description is "Query builder to fetch all EPMDocuments which do not have a associated WTPart". It looks like a solution to my problem but when tested it the result was showing also drawings (*.drw), family table members (associated with wtparts) and cad parts which name is different from corresponding WTpart name (these are also associated with wtparts).

Could someone help me to adapt this query to my requirement?

1 reply

Y
ybagul1-Visitor
1-Visitor
April 29, 2015

You can try adding criteria for .prt or .asm. Like in my case, following worked.

    MarcoTosin
    21-Topaz I
    MarcoTosin21-Topaz I
    21-Topaz I
    April 29, 2015

    Yogesh,

    I have linked this discussion at this document Resource for reporting

    In it there is also the article cited by Pawel.

    Now both are paired.

    Thanks

    Marco
      Terms & ConditionsAccessibility statement