Skip to main content
D
Dennis_V_NL8-Gravel
8-Gravel
December 26, 2023
Solved

Windchill search

  • December 26, 2023
  • 2 replies
  • 1979 views

Dear all, first of all: have a nice Christmass day! I fill my time in between visiting friends and family with some Windchill challenges:

- One of the users reported that the Structure within Windchill sometimes does not reflect the structure of the CAD model.

 

I did some research, looked for CAD settings like "Exclude from Bill of Materials" and eventually found out that 4 CAD parts were checked-in but where not associated with their Windchill parts. The Windchill parts are available. So it seems the user did not use auto-associate at first  ckech-in. 

Once found these issue's are easy to solve. But now I want to check all server data for more non-associated CAD data and make sure this can not happen in the future. And with these topics I can use some help:

 

- how can I make a Windchill query searching for CAD models that are not associated to a Windchill part?

- how can I restrict users from checking in CAD parts without associating the parts to a WTpart?, difficulty is that there are some "prototype" CAD parts that people should be able to check-in without associating. These prototype-CAD parts all have numbers starting with a "D" 

 

Best regards,

And wishing all happy holidays!!

 

Dennis Varkeviser

Best answer by avillanueva

This join using query builder will give you a list of all parts associated to CAD:

avillanueva_0-1703598245352.png

What you then need to do is construct a query for all cad docs who are not in that query above. You can use a subquery to do this. You can also add any other conditions you need to exclude those prototype parts.

 

2 replies

avillanueva
23-Emerald I
avillanueva23-Emerald IAnswer
23-Emerald I
December 26, 2023

This join using query builder will give you a list of all parts associated to CAD:

avillanueva_0-1703598245352.png

What you then need to do is construct a query for all cad docs who are not in that query above. You can use a subquery to do this. You can also add any other conditions you need to exclude those prototype parts.

 

    D
    Dennis_V_NL8-GravelAuthor
    8-Gravel
    December 27, 2023

    Thanks for the reply, I will have to dive deeper into Windchill queries to resolve. 

    S
    Sandeep_S_Desai14-Alexandrite
    14-Alexandrite
    December 26, 2023

    @Dennis_V_NLTry something like https://www.ptc.com/en/support/article/CS268136.. you can add that IBA in CAD template and make it mandatory in Type and Attribute Manager. OR other option could be to customize Auto Associate Part Finder Creator.

     

    Thanks,
    Sandeep Desai

    D
    Dennis_V_NL8-GravelAuthor
    8-Gravel
    December 27, 2023

    I will look into the article you mentioned. Thanks!

     

    Terms & ConditionsCookie settingsAccessibility statement