Skip to main content
R
rleir17-Peridot
17-Peridot
January 6, 2024
Solved

CADSYNCHRONIZED

  • January 6, 2024
  • 1 reply
  • 2803 views

Team

I don't see a CADSYNCHRONIZED field in QueryBuilder PartUsage WTPartUsageLink. 

Why? Do I need to install something?

 

The field should exist according to:

 

'Table Name: WTPartUsageLink has column called “CADSYNCHRONIZED” with values “yes|no”'
https://community.ptc.com/t5/Windchill/report-for-CAD-to-Part-structure-comparison/m-p/913189

and

https://www.ptc.com/en/support/article/CS332588

 

'Attributes; localId, ufid, externalTypeId, traceCode, lineNumber, cadSynchronized, componentId'
https://support.ptc.com/help/windchill/r12.1.2.0/en/index.html#page/Windchill_Help_Center/customization/WCCG_PLM_AP242_WTPartUsageLink.html

 

Best answer by joe_morton

You might find this helpful. This is a report template I created that returns WTPart structures that have not been "built". Just keep in mind that if a WTPart structure is updated after the CAD check in, it will get flagged as not "built" (even if it was built during the initial check in). I have a data monitor that runs weekly to find issues and address.

Another thing to keep in mind is that certain errors in the CAD models (such as failed placements) will prevent Windchill from doing the Build, even if the engineer has it set to build on check in.

 

joe_morton_0-1704745121903.png

joe_morton_1-1704745142500.png

 

The key criteria is EPMBuild History.Status = 1. 

I have Administrative Domain.Name like "default" to help eliminate returning items in Workspaces.

I also am omitting Obsolete parts 

joe_morton_2-1704745154225.png

 

The subselect is just to get latest revisions:

joe_morton_3-1704745179597.pngjoe_morton_4-1704745188664.pngjoe_morton_5-1704745200720.png

 

Hope that's helpful!

1 reply

G
GrahamV12-Amethyst
12-Amethyst
January 6, 2024

It should appear as 'Build Status' in Query Builder.

    R
    rleir17-PeridotAuthor
    17-Peridot
    January 8, 2024

    Here are the options for  PartUsage.Build Status :

    rleir_0-1704730006041.png

     

    but PartUsage does not relate to CADs?

    In EPMBuildRule I have no Build Status field. There is a field 'Cad Representation Role' which seems to always be yes. I is that the field for CADSYNCHRONIZED ?

    G
    GrahamV12-Amethyst
    12-Amethyst
    January 8, 2024

    Build Status is an indication of whether a WTPartUsageLink was built from CAD (or vice versa, you can build CAD structures from WTParts), it's useful for identifying parts that have been manually structured. Sounds like it's not what you're after though, what are you trying to achieve?

      Terms & ConditionsAccessibility statement