Is it possible to retrieve File vault location(Primary, custom folders) from Agile Schema
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
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;
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