Skip to main content
17-Peridot
Jan 6, 2024 12:36 PM UTC
Solved

CADSYNCHRONIZED

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

 

joe_morton
19-Tanzanite
Jan 8, 2024 8:26 PM UTC

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!

7 replies

12-Amethyst
Jan 6, 2024 11:15 PM UTC

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

Translate
rleir17-PeridotAuthor
17-Peridot
Jan 8, 2024 4:12 PM UTC

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 ?

Translate
12-Amethyst
Jan 8, 2024 5:28 PM UTC

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?

Translate