nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.