This content has been marked as final. Show 3 replies
See here: http://docs.oracle.com/cd/E23943_01/doc.1111/e10792/c08_migration.htm#CHDHJHDI
It clearly states "You can export revisions that are in RELEASED, DONE, EXPIRED, and GENWWW status. You cannot export revisions that are in an active workflow (REVIEW, EDIT, or PENDING status) or that are DELETED."
Thanks for your response.
This means Archiver doesn't touch workflow content but for my case, what should be the simplest approach ??
I was planning to delete document revisions (with Review status and under workflow) from revision table but this will not make my system in synch as we might have reference for these document in other tables as well. Can you suggest the all tables which I need to see for deleting my desired documents.
IMHO, deletion of a document which is in a workflow is a very bad practice - you will confuse your contributors, if nothing else.
If you really have good reasons, you can write a custom component, which will either release the documents according to your selected criteria, or deletes them right away. I'd stick as much as possible to the standard functionality - check how Repository Manager behaves, if that is done manually.
I'd definitely not go with direct database deletions - you will very easily end up with the inconsistent database, plus, your items are in a workflow, whose state is kept on the filesystem. I believe that RepoMan will use a service, so you might do the same.