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

[EMore]

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.

[HelesicPetr · Accepted solution]

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

[anursingh]

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