JQL query help with Initiatives and subtasks

Question

This the jql query I have, this shows all the canceled initiatives but also want to display the initiatives that are in progress that have a sub task canceled but not show the canceled subtask just the initiative in progress with the canceled subtask.

project in (A, B)  and issuetype in (A-Initiative, "B Initiative") and status in (Canceled)

Rachel Wright · Answer

Hi @Joe , you can use the standard "Filter Results" gadget and simply show the "Sub-Tasks" column.  Here's an example:

You can scan through the list visually and see that since DEMO-37 is crossed out ("resolved") then it's parent issue, DEMO-1, meets the condition you were trying to query for.

Click the "..." icon on the top right of the individual gadget to add and remove columns.

Hope this helps!

Rachel Wright

Joe_d50cxj · Answer

@Rachel Wright How would the dashboard be created? I tried rich filter results and rich filter two dimensional statistics.

Daniel Turczanski - JQL Search Extensions · Answer

Hi Joe,
With standard JQL you can only do some basic search

Standard JQL doesn't easily allow it but the results can be quickly found using our professional indexing service JQL Search Extensions.

To find active initiatives with cancelled epics:

issue in parentsOfIssuesInQuery("status=Cancelled") and type=Initiative and resolution is empty

To find active initiatives with any cancelled tickets in the hierarchy tree:

issue in parentsOfIssuesInQueryRecursive("status=Cancelled") and type=Initiative and resolution is empty

You can check out our docs for more information.

I hope this helps!
JQL Dan