Column in a view with epic priority

[Martin Härri]

Hi, I have a filter which extracts all stories of a project with specific criteria. I would now add a column to the view which shows the priority of the linked epic (not the priority of the story itself, but the epic it is linked to).

I'd appreciate if someone could give me a hint on the syntax of that custom column. Thanks!

[Rik de Valk · Accepted solution]

Hi @Martin Härri , with Jira issue search, you cannot join data. It basically only provides a single flat table with issues and its attributes. 

As such, you can only filter and report on attributes of the issues themselve. 

A solution (or work-around) would thus be, to make the 'Epic priority' an attribute of the issues. That would entail: 

1. Make a new custom field 'Epic priority' 
2. Add this new field to the screens of your Stories
3. Create an automation rule to copy the Priority of the Epic to the 'Epic priority', triggered on the field change of Parent on the Story
4. Create a second automation, similar to the first one, but triggered on a change of the Epic's priority

Hope that helps. 

Have a nice day! Rik 

[Martin Härri]

Thank you for the clarification, Rik!
I think I'll try a different approach then.

Btw: do you know if it would be possible with Structure? Afaik the formula language there is not JQL, but Expr