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

Add Comment
1 Answer(s)

SELECT DISTINCT APPLICATIONDATA.FILENAME, FVMOUNT.PATH, LPAD(TRIM (TO_CHAR (FVITEM.UNIQUESEQUENCENUMBER, 'xxxxxxxxxxxxxx')), 14, '0') AS ENCRYPTEDFILENAME<br /> FROM FVITEM, APPLICATIONDATA, FVMOUNT<br /> WHERE FVITEM.IDA3A4 = FVMOUNT.IDA3A5 AND (FVITEM.IDA2A2, APPLICATIONDATA.FILENAME) IN (<br /> SELECT IDA3A5,FILENAME FROM (<br /> SELECT APPLICATIONDATA.IDA3A5,<br /> APPLICATIONDATA.FILENAME<br /> FROM APPLICATIONDATA<br /> WHERE (<br /> APPLICATIONDATA.ROLE = 'PRIMARY'<br /> AND APPLICATIONDATA.IDA2A2 IN ( <br /> SELECT DISTINCT HOLDERTOCONTENT.IDA3B5 FROM HOLDERTOCONTENT, WTDOCUMENT<br /> WHERE HOLDERTOCONTENT.IDA3A5 IN (<br /> SELECT IDA2A2 FROM (<br /> SELECT WTDOCUMENT.IDA2A2 FROM WTDOCUMENT, WTDOCUMENTMASTER<br /> WHERE ( <br /> WTDOCUMENT.IDA3MASTERREFERENCE = WTDOCUMENTMASTER.IDA2A2<br /> AND WTDOCUMENTMASTER.WTDOCUMENTNUMBER = '0000000062'<br /> AND WTDOCUMENT.LATESTITERATIONINFO = '1'<br /> AND WTDOCUMENT.STATECHECKOUTINFO IN ('c/i', 'wrk') )<br /> ORDER BY WTDOCUMENT.CREATESTAMPA2 DESC<br /> )<br /> WHERE ROWNUM = 1<br /> )<br /> ) <br /> )<br /> ORDER BY APPLICATIONDATA.CREATESTAMPA2 DESC<br /> )<br /> WHERE ROWNUM = 1<br /> )

Add Comment

Your Answer

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