Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Document Counts in Projects

Avatar

Level 2

I'm attempting to create a report which lists by project the total count of documents by project.

As a bit of background, we had an API call run wild and duplicate documents. In some instances, this was by the 1000! The report is to help us identify the projects where this happened.

I've tried a number of solutions and the closest I came was to use a collection to list the names of the documents. I was hoping to run a calculation based on that but could not find anything. I'd appreciate any suggestions please!

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

3 Replies

Avatar

Level 6

Hi Rich,

For that you'd want to start with a Document based report, then add a Grouping by Project name. Flip from the Detail to the Summary page and you'll have your counts.

Filter for documents uploaded during the time your API got opinionated and you should get a solid list to go fix. Sympathy on that front!

Katherine

0694X00000DUCDmQAP.jpg

Avatar

Level 10

Hi Rich,

Similar to Katherine's approach, in times of triage, I sometimes prefer to go Bare Metal API, and invite you to use this gem to do effectively the same thing, from a URL (provided you change [yourdomain] and the two dates to match your situation):

https://[yourdomain].my.workfront.com/attask/api/v12.0/docu/report?fields=project:name&project:name_...

Regards,

Doug