Structure - showing the parent of an issue in a column

[francis]

We have 2 structures

* A structure (A) allowing us to categorise epics along a number of initiatives

* A structure (B) showing the status of the epics

We would now like to see the parent of the epic in structure A as a column in structure B

For instance

* Structure A

** Infrastructure

*** Cloud

- EPIC 1

- EPIC 2

In Structure B - I can see

EPIC 1  | Cloud

EPIC 2 | Cloud

How would you do this?

[Egor Tasa [ALM Works] · Accepted solution]

Hi Francis,

It seems that currently there is no straightforward solution for your requirement. We want to introduce JQL into formulas eventually, so it eventually may become possible, but not at the moment. 

You can use Effectors in structure A to put parent names into custom fields, but effectors are not automatic, you have to trigger them manually, so alternative would be to use ScriptRunner for the same purpose, though it will require some development. Still these are not very good solutions.

Sorry for the inconvenience.

Regards,
Egor

[francis]

Hi @Egor Tasa [ALM Works] 

How would you use an effector to update a custom field with the name of the parent 'memo'

Once configured - do you need to run the effector again manually whenever an issue moves from one parent memo to another parent memo

If effectors are not the way - do you have an example scriptrunner script to retrieve the parent memo name. 

How would you catch the event that an issue is moved from one to another memo, and what event to catch if the parent memo name is changed?

Looking forward for your feedback

[Egor Tasa [ALM Works]]

Hi Francis,

Effectors indeed would have to be run every time the issue is moved (the formula for effector would be something like PARENT{key} or something similar.

Unfortunately, I cannot provide any examples of ScriptRunner scripts here. In automated structures, you would have to check for issue change or link events as moving issues in automated structure (or changing parent name) correspond to changes in Jira. 

Regards,
Egor

[francis]

The parent attribute doesn't seem to exist.  I have been browsing through all the different - but nothing seems to reflect the name of the parent memo.

[Egor Tasa [ALM Works]]

Hi Francis,

You'd have to add Formula column, to enter the formula.

Here is a bit of documentation on Formula columns: https://wiki.almworks.com/display/structure/Formulas

And this is about Aggregate Functions (like PARENT): https://wiki.almworks.com/display/structure/Aggregate+Function+Reference

Please, let me know if you have questions.

Regards,

Egor

[Patricia Francezi]

You can use boards to see them separetely filtering the epics you want to see, but not showing each as columns. 

Kanban boards use columns as an underlying workflow and its statuses. 

Unless you have different status for each type of epic (which I dont  recommend), you are not able to seem them in columns separetly. 

[francis]

Hi @Patricia Francezi - this question relates to the Structure app from ALM Works