HELP!! Trying to write a JQL that will display only stories associated with a deliverable. Any clu

John Chanter November 28, 2023

I'm hopeful there's a simple JQL that will display stories associated with a deliverable.  I keep bumping up against epics...but need the story list.

1 answer

1 accepted

0 votes
Answer accepted
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 28, 2023

Hello @John Chanter 

Welcome to the Atlassian community.

In Jira terms what is "a deliverable"? Is it a type of issue? What type of issues is it? How are stories associated to it?

Can you provide a screen image of "a deliverable" that includes showing the stories associated to it?

John Chanter November 28, 2023

Sure - our deliverables sit atop the Jira work hierarchy, and are represented in the Parent Link field of the epic.  When I query on parent link, Jira returns epics associated with that parent link/deliverable.  I need a return of stories that support the epics.

Not sure how to attach to this thread :(

Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 28, 2023

From this page:

https://support.atlassian.com/jira-software-cloud/docs/search-for-advanced-roadmaps-custom-fields-in-jql/

Look at the information on the portfolioChildIssuesOf function.

 

  • To get all child issues below INIT-00 and not just the child issues at the epic hierarchy level:

    issuekey in portfolioChildIssuesOf("INIT-001")
  • if you want to return just the story-level issues: 

    issuekey in portfolioChildIssuesOf("INIT-001") AND issueType = Story
  • If needed, you can skip returning issues of the hierarchy levels you don't need:

    issuekey in portfolioChildIssuesOf("INIT-001") AND issueType != Epic.
John Chanter November 30, 2023

Many thanks!

Like Trudy Claspill likes this

Suggest an answer

Log in or Sign up to answer