Skip to main content
E
EMore4-Participant
4-Participant
October 6, 2025
Solved

How to get View Part information from DB table with query sql

  • October 6, 2025
  • 2 replies
  • 396 views

Hello to everyone,

I am using Windchill PDMLink Release 12.0 and Datecode with CPS 12.0.2.19

 

I'm making a query that extract a specific Bom in a specific version and View (ex. manufacturing View).

I need to know in wich table of the Database there is the View Part information. I need the manufacturing view.

 

Can someone help me? thanks.

Best answer by HelesicPetr

Hello @EMore 

here is an example of SQL query with innerjoin from wtp to wtpmaster and wtp to view

select wtv.name,wtpmaster.WTPartNumber,* from wcuser.WTPart WTP
inner join wcuser.WTView wtv on WTP.idA3view=wtv.idA2A2
inner join wcuser.WTPartMaster wtpmaster on WTP.idA3masterReference=wtpmaster.idA2A2
where wtv.name = 'Manufacturing'

hope this can help

 

PetrH

2 replies

HelesicPetr
22-Sapphire II
HelesicPetr22-Sapphire IIAnswer
22-Sapphire II
October 7, 2025

Hello @EMore 

here is an example of SQL query with innerjoin from wtp to wtpmaster and wtp to view

select wtv.name,wtpmaster.WTPartNumber,* from wcuser.WTPart WTP
inner join wcuser.WTView wtv on WTP.idA3view=wtv.idA2A2
inner join wcuser.WTPartMaster wtpmaster on WTP.idA3masterReference=wtpmaster.idA2A2
where wtv.name = 'Manufacturing'

hope this can help

 

PetrH

    A
    anursinghCommunity Manager
    Community Moderator
    October 22, 2025

    Hi @EMore,

     

    I wanted to see if you got the help you needed.

    If so, please mark the appropriate reply as the Accepted Solution. It will help other members who may have the same question.
    Of course, if you have more to share on your issue, please pursue the conversation. 

     

    Thanks,
    Anurag 

    Terms & ConditionsCookie settingsAccessibility statement