Topic
  • No replies
drdamour
drdamour
40 Posts

Pinned topic Best way to retrieve all versions of documents filed within a folder

‏2012-07-03T18:49:03Z |
i have the need to generate a report of all the versions of any document filed within a specific folder (any level of descendants). Currently i'm doing this as a two pass process, first finding all the docs filed in the folder (using INSUBFOLDER actually), then finding all the versions for each document in the result set 1 by 1.

I'm hoping there's some way to do a join or some keyword/function that can perform such a query for me more efficiently. Something like:

SELECT ID FROM DOCUMENTS WHERE INSUBFOLDER('/path/') AND ALLVERSIONS;

But i'm open to any suggestions


I am Just a new Boy,
A Stranger in this Town,
Where are All the Good Times,
Who's Gonna Show this Stranger Around?
Check out our Agile ACM Catalogue: Widgets, APIs, & Components for Building Solutions