Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X
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.
Solved! Go to 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
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
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
