Skip to main content
Christina_Jarosz
Level 9
Oct 17, 2021 1:51 PM UTC
Solved

Documents report filtered on location folder?

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.
Richard_Le_
Richard_Le_Accepted solution
Community Advisor
Oct 17, 2021 10:45 PM UTC

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.

2 replies

Richard_Le_
Community Advisor
Richard_Le_Community AdvisorAccepted solution
Community Advisor
Oct 17, 2021 10:45 PM UTC

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.

Translate
Mr_Anderson_
Level 2
Oct 28, 2022 9:15 AM UTC

Hi Richard,

 

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

 

thanks

 

Jonathan

Translate