How to identify document revision/ documents without connected object/ attached few years ago, .. and remove them from IFS?

Question

Hi All,Are you familiar with a solution that can permanently remove all detached document revisions from the system (Customer is using Applications 10)?Additionally, the deletion process needs to identify and remove documents based on their attached date — specifically, those attached more than five days ago (Attached_Date < SYSDATE - 5).	I'm also exploring whether it's possible to separate attachments (e.g., PDF, JPEG files) from BLOB entries in the IFSAPP_LOB table, assuming this is where the documents are stored.Any suggestions on how to approach this would be greatly appreciated.Thank you.Kind regards,Santhushi D.

SanthushiD · Answer

Hi All,Are you familiar with a solution that can permanently remove all detached document revisions from the system (Customer is using Applications 10)?Additionally, the deletion process needs to identify and remove documents based on their attached date — specifically, those attached more than five days ago (Attached_Date < SYSDATE - 5).I'm also exploring whether it's possible to separate attachments (e.g., PDF, JPEG files) from BLOB entries in the IFSAPP_LOB table, assuming this is where the documents are stored.Any suggestions on how to approach this would be greatly appreciated.Thank you.Kind regards,Santhushi D.We are currently in the process of identifying document revisions or documents that are not connected to any object or attachment, with the intention of removing them from IFS.Initially, when a document is detached from the corresponding table or logical unit (LU), it still remains within the Document Revision module. Our goal is to determine whether there is a method to identify all such detached document revisions in the system and remove them permanently.In addition, we would like to clarify how to determine whether documents are stored in the database or in an external file location.While running a simple query on the EDM_FILE_STORAGE_TAB, we noticed that the FILE_DATA column contains <BLOB>.Does this indicate that the documents are stored within the database?Or is it only a reference, with the original file stored externally?Any help on this would be great! :)EDM_FILE_STORAGE_TAB FILE_DATA column detailsThank you.Kind regards,Santhushi D.

Did you find what you're looking for? If not:

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded