Skip to main content
1-Visitor
Feb 17, 2016 11:40 AM UTC
Solved

how to get the WORKPACKAGE data

Hello,

Does any one know how do we can retrieve the data from the WORKPACKAGE using database script

2-Explorer
Feb 17, 2016 12:24 PM UTC

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

2 replies

2-Explorer
Feb 17, 2016 12:24 PM UTC

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

Translate
adev1-VisitorAuthor
1-Visitor
Feb 17, 2016 1:02 PM UTC

Thank you so much Binesh

Translate