I'm looking for a way to retry and if needed remove all documents located inside the tree of a given folder root with all of their versions, not just the current one.

The easiest way might be a SQL query with a batch deletion. Since previous version of a document are not filed in a Folder, I proceeded to do it this way:

• Perform a SELECT request on Document class
• Add a left join between a document version (Document as doc) and other versions (Document as doc2) using version_series key.
• Filter to get only current version from other versions (doc2.IsCurrentVersion = true)
• Filder to get only documents whose current version is filed in a given Folder tree (INSUBFOLDER clause)

Additional step:

• Left joins with ReferentialContainmentRelationShip and Folder classes to get the Path Name of the document current version Folder

The final request looks like below:

Is a good and not overkill way to achive what the goal?

Are you doing the join only to get all versions of a document? If yes, that would seem an overkill to me. Something like

WHERE IsCurrentVersion in (true, false)

looks sufficient to me.

I think there is even an easier way, but can't remember what it was :-(

/gerold

Hello Gerold,

Thanks for your answer. I'm not sure to understand your WHERE clause. Are you suggesting this:

Such request would return all Documents.

Regards.