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?

W
WorkfrontWhiff
Level 3
March 6, 2025

it's because there are too many hops.

You can read up on too many hops here:

https://experienceleaguecommunities.adobe.com/t5/custom/page/page-id/GlobalSearch#q=too%20many%20hops&sort=relevancy&f:@el_contenttype=[Community]&f:el_product=[Workfront]

 

The usual workaround for too many hops is the exists filter, which you can read up on here:

https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/text-mode/create-complex-text-mode-filters-using-exists-statements

 

a sample filter might look something like this (I'm not sure, because I didn't test it out, but they generally follow this type of format):

 

EXISTS:a:$$OBJCODE=USER

EXISTS:a:ID=FIELD:project:ownerID

EXISTS:a:homeTeamID=62a797f700141a8af48689d780cfffee


I would like to jump on the back of this thread please!

I have followed your instructions and use this text mode:

 

folders:name=final
folders:name_Mod=cicontains
owner:homeTeamID=ABC123
owner:homeTeamID_Mod=in
project:status=CPL CUR
project:status_Mod=in

 

without the 'owner' text mode, it shows up what I need it to, but ALL docs. I would like to filter it down by project owner but it then shows me nothing.

 

When NOT using text mode and using Standard Mode, owner ID and project status works, but I need the file in the Final folder.

 

Where am I going wrong?

Thank you!

Terms & ConditionsAccessibility statement

Loading footer...