Document Counts in Projects | Community
Skip to main content
R
RichJo2
April 30, 2021
Question

Document Counts in Projects

  • April 30, 2021
  • 3 replies
  • 928 views

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!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

K
Community Advisor
KatherineLaCommunity Advisor
Community Advisor
April 30, 2021

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

Doug_Den_Hoed__AtAppStore
Community Advisor
Doug_Den_Hoed__AtAppStoreCommunity Advisor
Community Advisor
April 30, 2021

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_1_GroupBy=true&lastUpdateDate=2021-01-01&lastUpdateDate_Range=2021-03-01&lastUpdateDate_Mod=between

Regards,

Doug

    RandyRoberts
    Community Advisor
    RandyRobertsCommunity Advisor
    Community Advisor
    April 30, 2021

    "Bare Metal API", lol! 😂

    Terms & ConditionsAccessibility statement

    Loading footer...