Documents report filtered on location folder? | Community
Skip to main content
Christina_Jarosz
Level 9
October 17, 2021
Solved

Documents report filtered on location folder?

  • October 17, 2021
  • 1 reply
  • 965 views

I would like to create a document report (or project report) that allows to filter if any documents exist in a specific custom folder.

Is this possible?

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

Hi Christina,

Using an EXISTS filter, you could produce a Document report that only returns documents in a folder with a specific folder name. The following text mode would enable you to do this.

EXISTS:a:$$EXISTSMOD=EXISTS

EXISTS:a:$$OBJCODE=DOCFLD

EXISTS:a:documentID=FIELD:ID

EXISTS:a:folder:name=The Name Of Your Doc Folder Here

EXISTS:a:folder:name_Mod=eq

If it is a very specific folder you are looking at, I would also add an additional filter rule to only look at documents on a specific project or task . This will ensure that if there are other document folders in your instance that are named the same, those documents appear in your report.

Best Regards,

Rich.

1 reply

Richard_Le_Community AdvisorAccepted solution
Community Advisor
October 17, 2021

Hi Christina,

Using an EXISTS filter, you could produce a Document report that only returns documents in a folder with a specific folder name. The following text mode would enable you to do this.

EXISTS:a:$$EXISTSMOD=EXISTS

EXISTS:a:$$OBJCODE=DOCFLD

EXISTS:a:documentID=FIELD:ID

EXISTS:a:folder:name=The Name Of Your Doc Folder Here

EXISTS:a:folder:name_Mod=eq

If it is a very specific folder you are looking at, I would also add an additional filter rule to only look at documents on a specific project or task . This will ensure that if there are other document folders in your instance that are named the same, those documents appear in your report.

Best Regards,

Rich.

Mr_Anderson_
Level 2
October 28, 2022

Hi Richard,

 

Is it similarly possible to apply a grouping to a report by project document folder?

 

thanks

 

Jonathan