Displaying Jira Issues and Subtasks in Confluence

Question

Greetings!

I am using Confluence as a method to status our Jira tickets. I have been successful in setting this up in such a way that all Issues are populating to Confluence, however the subtasks under a related Issue is NOT populating.

I there way that I can create my Confluence to "auto-include" all subtasks for any given story without having to manually create a query using the "parent = " for each Issue having a subtask?

At the end of the day I'd like to create a reusable query that will automatically pull in any related subtask of an Issue when one exists.

Thanks in advance for your help!!

Greg Ahl · Answer

Thanks so much @Kai Becker - I'll give this a test!!

Kai Becker · Answer

Hi @Greg Ahl ,

thanks for the clarification. you should be able to solve your problem, by adding the following right before the order by part:

"parentEpic" IN (SBD-2812)

This should also pull over all sub tasks belonging to issues with the specific EPIC.

Greg Ahl · Answer

Kai,

I have a simple Confluence page that is set up to pull (display) issues automatically from jira using the Confluence "Insert JIRA Issue/Filter" widget. In that widget, I am use JQL to pull in jira issues based Status, Epic Link and the filtered by labels. (see EX below)

status in (Analyzing, Backlog, New, Open, Ready, "To Do", Triaged) AND "Epic Link" = SBD-2812 AND labels != Internal_Use order by created DESC