Document report on files sitting within subfolders

Forum|Forum|3 months ago
October 24, 2025
1 reply
225 views

I have a document report which shows all files within a task folder called Final Files. However on occasions our team is creating subfolders and the report is not picking up any of the files that sit within those subfolders. The subfolder names are not consistent and therefore unable to pick up with an AND: for an additional folder name.

I am currently using this text mode which works if the files are sitting directly under the Final Files:
EXISTS:a:$$EXISTSMOD=EXISTS
EXISTS:a:$$OBJCODE=DOCFLD
EXISTS:a:documentID=FIELD:ID
EXISTS:a:folder:name=Final Files
EXISTS:a:folder:name_Mod=eq
projectID=XXXXXXX

Any help would be really appreciated.
projectID_Mod=in

Best answer by KellieGardner

Try this instead.

EXISTS:a:$$EXISTSMOD=EXISTS
EXISTS:a:$$OBJCODE=DOCFDR
EXISTS:a:documents:ID=FIELD:ID
EXISTS:a:parent:name=Final Files

KellieGardner

Accepted solution

Community Advisor

Try this instead.

EXISTS:a:$$EXISTSMOD=EXISTS
EXISTS:a:$$OBJCODE=DOCFDR
EXISTS:a:documents:ID=FIELD:ID
EXISTS:a:parent:name=Final Files

W

WorkfrontWhiffAuthor

Level 3

Thanks @kelliegardner I managed to get the results I needed using something really similar and duplicating for each of the unique subfolders:

OR:1:EXISTS:a:$$EXISTSMOD=EXISTS
OR:1:EXISTS:a:$$OBJCODE=DOCFLD
OR:1:EXISTS:a:documentID=FIELD:ID
OR:1:EXISTS:a:folder:ID=XXXXXXXXXXXXX
OR:1:EXISTS:a:folder:name_Mod=eq

Not sustainable doing it this way, but it was a workaround.
I will use your suggestion and see if I get the results I needed, your suggestion may be the sustainable way.

Appreciate the reply.

KellieGardner

Community Advisor

The one I provided will look at the "parent" folder instead of the subfolder

Documents Section

Final Files Folder (<-------this is what it will identify)
- Sub Folder
- Sub Folder
  - Sub Folder

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded