Community Tip - New to the community? Learn how to post a question and get help from PTC and industry experts! X
Hello,
Does any one know how do we can retrieve the data from the WORKPACKAGE using database script
Solved! Go to Solution.
SELECT DISTINCT wpm.name,wpm.packagenumber,epmM.name
FROM PersistedCollection pc,WorkPackage wp,WorkPackageMaster wpm, epmdocument epm, epmdocumentmaster epmM,PersistedCollectionLiveLink pcLink
WHERE epm.idA3masterReference=epmM.idA2A2 AND wp.ida3masterreference= wpm.ida2a2 AND (((pc.idA3A5 = wp.idA2A2) AND (pcLink.idA3B4 = epm.idA2A2)
AND (pc.idA2A2 = pcLink.idA3A4) AND (pcLink.roleBisSeed = 0))) ORDER BY wpm.packagenumber;
This should work. You have to join wtdocument as well to get documents.
Thank you
Binesh Kumar
Medtronic - MITG
SELECT DISTINCT wpm.name,wpm.packagenumber,epmM.name
FROM PersistedCollection pc,WorkPackage wp,WorkPackageMaster wpm, epmdocument epm, epmdocumentmaster epmM,PersistedCollectionLiveLink pcLink
WHERE epm.idA3masterReference=epmM.idA2A2 AND wp.ida3masterreference= wpm.ida2a2 AND (((pc.idA3A5 = wp.idA2A2) AND (pcLink.idA3B4 = epm.idA2A2)
AND (pc.idA2A2 = pcLink.idA3A4) AND (pcLink.roleBisSeed = 0))) ORDER BY wpm.packagenumber;
This should work. You have to join wtdocument as well to get documents.
Thank you
Binesh Kumar
Medtronic - MITG
Thank you so much Binesh