Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JQL Help - Displaying a story's epic and initiative with JQL

Hello Jira Guru's!  I need some JQL help (hopefully without purchasing another product, but if that's what you've got- let me know).

We have this hierarchy in Jira with now Jira Premium (Advanced Roadmaps, formerly Portfolio).   

Initiative 1

---- Epic 1

----------Story 1

----------Story 2

---- Epic 2

----------Story 1

----------Story 2

 

There are times where I'm querying and looking at a set of stories and I'd like to show the story's epic and initiative.  I want to go 'up the hierarchy' and see what Epic and Initiative the story it belongs to and I can't find out how to do this.  Please help!  

 

1 answer

0 votes
John Funk Community Leader Feb 16, 2021

Hi Tina,

Are talking in a filter? Do you need to just see the results or use it?

I am thinking just display the Epic Link and the Linked columns in your filter result. But that's probably too simple. 

We can use a filter to return the desired user stories, but not necessary.   So, for example, if our JQL is:  

Project = 'XXYZ' and "Target Release Date[Date]" = '2021-02-12' order by created DESC

The linked columns i've selected include: key, epic link, summary, status, target release date (custom field), and parent link.

So, the parent link isn't valid at the story level because that's the epic link.  What I really want is the parent link of the epic of the story that I want.  

Hopefully that clarifies.

John Funk Community Leader Feb 16, 2021

Yeah, you are probably not going to get that in a JQL.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira

Do you use Jira Cloud with Microsoft Teams?

Hi, Jira users! Do you use Jira alongside Microsoft Teams? We want to hear how you’ve used the power of Jira Cloud and Microsoft Teams (via the Jira Cloud for Microsoft Teams app) to achieve a team...

531 views 1 9
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you