Skip to main content
A
adev1-Visitor
1-Visitor
February 17, 2016
Solved

how to get the WORKPACKAGE data

  • February 17, 2016
  • 1 reply
  • 1790 views

Hello,

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

Best answer by BineshKumar1
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

1 reply

B
BineshKumar11-VisitorAnswer
1-Visitor
February 17, 2016
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

A
adev1-VisitorAuthor
1-Visitor
February 17, 2016

Thank you so much Binesh

Terms & ConditionsAccessibility statement