Home

File_Path for Secondary file manager vault files

Hello team,

If there are multiple file managers, how can I get the file path of files in the vault.

Is it present in FILE_INFO?

Please let me know.

Thanks,

manju

Agile User Asked on July 22, 2020 in Product Collaboration.
Add Comment
Cancel
1 Answer(s)

Hi Manju,

Please check if below queries work for you. You may Join these tables to get all Information.

 

SELECT ID FROM ITEM WHERE ITEM_NUMBER=’TEST_ITEM’;

RESULT: 6022378

 

SELECT  FILE_ID FROM ATTACHMENT_MAP WHERE PARENT_ID=’6022378′;

RESULT: 6216321

 

SELECT LOCATIONS,IFS_FILEPATH FROM FILE_INFO WHERE FILE_ID=’6216321′;

RESULT : 13388, 000/061/196/agile9342123.xls

 

SELECT DESCRIPTION FROM NODETABLE WHERE ID=’13388′;

RESULT: IFS

 

ACTUAL FILE PATH: BASE STORAGE DIRECTORY OF IFS(CONFIGURED IN JAVA CLIENT) EX : D\Vault

D:Vault\000\061\196\gile9342123.xls

 

 

Thank You

Cancel
Agile Talent Answered on August 20, 2020.
Add Comment
Cancel

Your Answer

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