How to get documents content location in Vault using SQL – Input is number

How to get documents content location in Vault using SQL – Input is number

Alex Trainee Asked on May 16, 2015 in Windchill PDMLink.
Add Comment
1 Answer(s)
SELECT DISTINCT APPLICATIONDATA.FILENAME, FVMOUNT.PATH, LPAD(TRIM (TO_CHAR (FVITEM.UNIQUESEQUENCENUMBER, 'xxxxxxxxxxxxxx')), 14, '0') AS ENCRYPTEDFILENAME
 FROM FVITEM, APPLICATIONDATA, FVMOUNT
 WHERE FVITEM.IDA3A4 = FVMOUNT.IDA3A5 AND (FVITEM.IDA2A2, APPLICATIONDATA.FILENAME) IN (
 SELECT IDA3A5,FILENAME FROM (
 SELECT APPLICATIONDATA.IDA3A5,
 APPLICATIONDATA.FILENAME
 FROM APPLICATIONDATA
 WHERE (
 APPLICATIONDATA.ROLE = 'PRIMARY'
 AND APPLICATIONDATA.IDA2A2 IN ( 
 SELECT DISTINCT HOLDERTOCONTENT.IDA3B5 FROM HOLDERTOCONTENT, WTDOCUMENT
 WHERE HOLDERTOCONTENT.IDA3A5 IN (
 SELECT IDA2A2 FROM (
 SELECT WTDOCUMENT.IDA2A2 FROM WTDOCUMENT, WTDOCUMENTMASTER
 WHERE ( 
 WTDOCUMENT.IDA3MASTERREFERENCE = WTDOCUMENTMASTER.IDA2A2
 AND WTDOCUMENTMASTER.WTDOCUMENTNUMBER = '0000000062'
 AND WTDOCUMENT.LATESTITERATIONINFO = '1'
 AND WTDOCUMENT.STATECHECKOUTINFO IN ('c/i', 'wrk') )
 ORDER BY WTDOCUMENT.CREATESTAMPA2 DESC
 )
 WHERE ROWNUM = 1
 )
 ) 
 )
 ORDER BY APPLICATIONDATA.CREATESTAMPA2 DESC
 )
 WHERE ROWNUM = 1
 )
guru@windchillguru.com Guru Answered on May 16, 2015.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.