Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Content Management (Extended ECM)
API, SDK, REST and Web Services
I'd like to create a LiveReport that counts the number of document versions under a specific folder
Rob_Perry_(Disabled)_(mitra01admin_-_(deleted))
Does anyone know how to create a report which counts the number of document versions within a specified folder tree?
Find more posts tagged with
Comments
Herb_Schilling_(x-nasalewisuser4_-_(deleted))
We designed this report for usage by individual users, but you can get the idea...select %1, count(*) "count(*)" from DTree, DVersData where %2 and (DTree.DataID = DVersData.DocID) and (%3) and (DTree.UserID = %4 OR DVersData.Owner = %4) and ( DTree.VersionNum >= %5 ) group by %1 order by count(*) descWhere -%1 = Report Fields%2 = Filter Documents%3 = Filter Permissions%4 = User Input for the User%5 = User Input for Minimum number of versions to look at.Hope this helps.
