Document Report to Identify Number of Files in a Specific Folder | Community
Skip to main content
M
mvsteep
Level 2
August 12, 2024
Question

Document Report to Identify Number of Files in a Specific Folder

  • August 12, 2024
  • 2 replies
  • 1511 views

Hi everyone! The problem I am trying to solve is develop a report (I started with a document report) to identify the number of files in a specific folder in our Project Folders (the folder we are targeting is called "Final Files"). We are attempting this because we want to see the number of final files that were deployed per project without creating a field in the project details where the project owner would manually select the number of final files deployed. My issue is the Document report has a Final Folder column but it is generating null for all results (which is odd because they all have files in that folder). Any idea how I could solve this request? Thank you!

2 replies

GrahamJarrett
GrahamJarrett
Level 4
August 12, 2024

I have just done something very similar in Fusion. I get all documents on a Project and then I get the collections of Folders. I then filter to the folder I want to count documents in and then I get all documents meeting a certain criteria. The Number of Bundles output is then the number I need. I store this on the Project.

 

Unfortunately you cannot do a Watch Event and filter documents by the folder so you have to use the Watch Record instead.

skyehansen
Community Advisor
skyehansenCommunity Advisor
August 13, 2024

If I'm not mistaken, you should be able to just reference it using a collections report like here:

https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/text-mode/reference-collections-report#reference-a-collection-in-the-filter-of-a-report

 

i.e. if I'm reading your question right, you would just create a filter for documents in final folders, and then group it by project name to find a count per project. Following instructions from the link above, the filter would probably look something like:

folders:name=final
folders:name_Mod=cicontains

M
mvsteepAuthor
Level 2
August 13, 2024

Thank you for the filter suggestion! I implemented it and my report finally brought in the results from the Final Folder. However, for projects that have more than 1 document in that folder the report was only showing the file that was most recently uploaded to the final folder. Any way to bypass that so i could bring in the correct count regardless of entry date?

skyehansen
Community Advisor
skyehansenCommunity Advisor
August 13, 2024

is it possible that there’s something else in your report filter affecting your results? I’m seeing two files in my final folder so the base filter works. 

Terms & ConditionsAccessibility statement

Loading footer...