Parent Folder Name in Proof Approval Report | Community
Skip to main content
KarthickNa1
Level 2
March 28, 2025
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

skyehansen
skyehansenAccepted solution
Level 4
March 31, 2025

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

View reply

7 replies

skyehansen
skyehansen
Level 4
March 31, 2025

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
Sven-iX
New Participant
March 31, 2025

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
skyehansenAccepted solution
Level 4
March 31, 2025

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
    Daniel_Clarke
    Daniel_Clarke
    New Participant
    March 28, 2025

    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
      Sven-iX
      Sven-iX
      New Participant
      March 28, 2025

      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
        Terms & ConditionsAccessibility statement

        Loading footer...