Skip to main content
Level 2
Mar 28, 2025 2:00 PM UTC
Solved

Parent Folder Name in Proof Approval Report

We would like to display a parent Folder name of the document in the Proof Approval report. Does anyone help us on this?

 

Many thanks,

Karthick N

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
skyehansen
skyehansenAccepted solution
Mar 31, 2025 11:33 PM UTC

Sven, you shouldn't need to -- as long as you use collections, which I know you try to avoid!

 

I suppose you could do some sort of "if parent.parent.parent.parentID is blank" cascading valueexpression, which I know I try to avoid.

 

You would just start with that collection and move forward.

 

listdelimiter=<p>
listmethod=nested(documentVersion.document.folders).lists
type=iterate
valuefield=name
valueformat=HTML

7 replies

Sven-iX
Community Advisor
Community Advisor
Mar 28, 2025 4:09 PM UTC

You can't - traversing from the docVersion to the document works but you cannot go further. 

That means you can get folderIDs and other properties on the document, but cannot follow the reference to folders to get the name.

 

You shouldn't use folders to "tag" or classify documents - use custom fields instead.

Translate
Daniel_Clarke
Adobe Champion and Community Advisor
Adobe Champion and Community Advisor
Mar 28, 2025 6:15 PM UTC

Hi @karthickna1! 

Unfortunately no, from a proof approval report I tested many possible connections on this from the documentVersion, nested(document.folders).lists, docfdr, folderIDs, and more without avail. 

@sven-ix is onto something though for using a custom form / field that could be attached at the document level (and filled through Fusion) that could pull in that identifying information along with additional metadata. 

Ping back if you have any additional questions around that!

Translate
skyehansen
Adobe Champion and Community Advisor
Mar 31, 2025 10:40 PM UTC

I don't think you can get the parent (the top most folder)? As far as I know, it's only possible to get the folder that contains the file. So if you have a structure like this:

 

Folder 1>

         Folder 2>

                    File

 

You can only get "Folder 2"

Translate
Sven-iX
Community Advisor
Community Advisor
Mar 31, 2025 10:56 PM UTC

From a DOCU object you can get up to 4 levels folders:parent:parent:parent:name

Bummer is I can't do that (not even the immediate folder) in a calculated field 

 

Translate
skyehansen
Adobe Champion and Community Advisor
skyehansenAdobe Champion and Community AdvisorAccepted solution
Mar 31, 2025 11:33 PM UTC

Sven, you shouldn't need to -- as long as you use collections, which I know you try to avoid!

 

I suppose you could do some sort of "if parent.parent.parent.parentID is blank" cascading valueexpression, which I know I try to avoid.

 

You would just start with that collection and move forward.

 

listdelimiter=<p>
listmethod=nested(documentVersion.document.folders).lists
type=iterate
valuefield=name
valueformat=HTML

Translate