Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!
SOLVED

Creating a report that shows a specific folder name with no documents

Avatar

Level 4

Hi community! 

Are there any suggestions to pull a report on all projects that have a specific folder (i.e. Final Deliverables) which is empty. 

 

I am trying to see all projects that are closed where someone didnt upload final documents.

 

Thanks! 

1 Accepted Solution

Avatar

Correct answer by
Level 10

Project Report Filter - return only Completed Projects without at least one file in a Particular Folder. 

EXISTS:a:$$EXISTSMOD=NOTEXISTS
EXISTS:a:$$OBJCODE=DOCFLD
EXISTS:a:document:projectID=FIELD:ID
EXISTS:a:folder:name=TYPE YOUR PARTICULAR FOLDER NAME HERE
EXISTS:a:folder:name_Mod=cicontains
status=CPL

More than one folder

OR:1:EXISTS:a:$$EXISTSMOD=NOTEXISTS
OR:1:EXISTS:a:$$OBJCODE=DOCFLD
OR:1:EXISTS:a:document:projectID=FIELD:ID
OR:1:EXISTS:a:folder:name=TYPE YOUR PARTICULAR FOLDER 1 NAME HERE
OR:1:EXISTS:a:folder:name_Mod=cicontains
OR:1:EXISTS:a:status=CPL
OR:2:EXISTS:a:$$EXISTSMOD=NOTEXISTS
OR:2:EXISTS:a:$$OBJCODE=DOCFLD
OR:2:EXISTS:a:document:projectID=FIELD:ID
OR:2:EXISTS:a:folder:name=TYPE YOUR PARTICULAR FOLDER 2 NAME HERE
OR:2:EXISTS:a:folder:name_Mod=cicontains
OR:2:EXISTS:a:status=CPL

 TIP: if this solved your problem, I invite you to consider marking it as a Correct Answer to help others who might also find it of use.
If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/mysocalledideas

View solution in original post

1 Reply

Avatar

Correct answer by
Level 10

Project Report Filter - return only Completed Projects without at least one file in a Particular Folder. 

EXISTS:a:$$EXISTSMOD=NOTEXISTS
EXISTS:a:$$OBJCODE=DOCFLD
EXISTS:a:document:projectID=FIELD:ID
EXISTS:a:folder:name=TYPE YOUR PARTICULAR FOLDER NAME HERE
EXISTS:a:folder:name_Mod=cicontains
status=CPL

More than one folder

OR:1:EXISTS:a:$$EXISTSMOD=NOTEXISTS
OR:1:EXISTS:a:$$OBJCODE=DOCFLD
OR:1:EXISTS:a:document:projectID=FIELD:ID
OR:1:EXISTS:a:folder:name=TYPE YOUR PARTICULAR FOLDER 1 NAME HERE
OR:1:EXISTS:a:folder:name_Mod=cicontains
OR:1:EXISTS:a:status=CPL
OR:2:EXISTS:a:$$EXISTSMOD=NOTEXISTS
OR:2:EXISTS:a:$$OBJCODE=DOCFLD
OR:2:EXISTS:a:document:projectID=FIELD:ID
OR:2:EXISTS:a:folder:name=TYPE YOUR PARTICULAR FOLDER 2 NAME HERE
OR:2:EXISTS:a:folder:name_Mod=cicontains
OR:2:EXISTS:a:status=CPL

 TIP: if this solved your problem, I invite you to consider marking it as a Correct Answer to help others who might also find it of use.
If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/mysocalledideas