Is it possible to retrieve File vault location(Primary, custom folders) from Agile Schema

Hello,

See below the query i use to get the ifsfilepath for attachments for documents. But since these can fall either in Custom or primary vault, it is difficult for me to copy the files.

Can you please tell me if it is possible to retrieve custom or primary vault details from DB.

or is it discretely done by ifs server manager.

select item.item_number ItemNumber,rev.Rev_number ParentRev,item.category EngRes,e.description ParentType,
FILES.FILENAME, FILE_INFO.IFS_FILEPATH, REV.LATEST_FLAG,VERSION_FILE_MAP.DESCRIPTION,FILES.FILE_SIZE,
FILE_INFO.CREATED,FILE_INFO.LAST_UPD,FILES.ID as FILES_ID,VERSION_FILE_MAP.VERSION_ID
from AGILE.item item inner join Agile.rev rev on rev.change=item.latest_released_eco and rev.item=item.id inner join Agile.nodetable e on item.subclass=e.id
inner join AGILE.ATTACHMENT_MAP ATTACHMENT_MAP ON ATTACHMENT_MAP.PARENT_CLASS = ITEM.CLASS AND ITEM.ID = ATTACHMENT_MAP.PARENT_ID
and attachment_map.parent_id2=rev.change
INNER JOIN AGILE.VERSION_FILE_MAP VERSION_FILE_MAP ON ATTACHMENT_MAP.LATEST_VSN = VERSION_FILE_MAP.VERSION_ID
INNER JOIN AGILE.FILES files ON VERSION_FILE_MAP.FILE_ID = FILES.ID INNER JOIN AGILE.FILE_INFO FILE_INFO on FILES.ID=FILE_INFO.FILE_ID
where item.category in ()
and item.class=9000 and item.delete_flag is null and e.description in ()
order by item.item_number;

 

Thanks,

manju

Agile User Asked on April 26, 2020 in Product Collaboration.
Add Comment
1 Answer(s)

Hello Manju

FILE_INFO has information that might help

– for records where ifs_filepath is NOT null, you can use the LOCATIONS attribute and join to parentid of propertytable where propertyid = 30. That will give you the vault name configured in Administrator. However, note that the LOCATIONS can have multiple vault ids separated by comma if the files are there in multiple vaults

– For custom(Inplace) vault, hfs_filepath will be NOT null AND ifs_filepath will be null. Atleast in our environment, I see the LOCATIONS attribute as null. I was expecting to have an id that

Hope this helps

– Raj

Agile Angel Answered on April 27, 2020.

Hello Raj,

Did try all these options, nevertheless in my DB hfs_filepath and location is null.

But I worked it out, using some dos commands in the file vault and imported the path details to the database, some queries then got the exact path.

Thank you for helping

Manju

on June 9, 2020.
Add Comment

Your Answer

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