How to find the full hierarchical folder path to an issue

Alan Wakeford_h63do2

Hello, 

I am doing some integration between Jira structure and an inhouse tool and need to determine the full structure folder path to an issue.

Say I have a structure that looks like this:

Fol1

    Fol2

          Issue1

Then for Issue1, I want to find the list {Fol1, Fol2} or some similar string. I would then store this string in the issue for later use.

Any help or ideas would be appreciated, thanks.

Alan

Dionathan Lopes {ALM Works}

Hello @Alan Wakeford ,

Dionathan from ALM Works here. Welcome to the Community!

We should be able to accomplish your goal by first adding a Formulas column. How we build the formula is going to depend on what the hierarchy is comprised of. 

For example: Lets consider a hierarchy with 4 levels: Folder 1 > Folder 2 > Epic > Story

By using formulas, you could use a CONCAT that joins together the text strings, and the PARENT function which will extract the value from the parent row or from an ancestor row by a specified level, as below:

 

CONCAT(PARENT#LEVEL=-3{SUMMARY}, "/", PARENT#LEVEL=-2{SUMMARY}, "/", PARENT{SUMMARY}, "/", THIS.SUMMARY)

You should see something like the below example:

Finally, you could use Effectors to write the value from the Formula column to the needed custom field.

Please let me know if it does help, or if you have any other questions.

Best Regards,
Dionathan