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
This topic has been locked.