jql to list all sub tasks related to filtered list of initiatives

Scott Federman_nptc3f

Hey all I have a JQL which filters out a list of issue type initiatives. I want to be able to pull a list of all related sub tasks as well. Is this possible. Or how would I pull a list of only the sub-tasks related to the initiatives that follow this JQL?

project = AI AND status in (Initiation, Dev, Planning, Completed, "Pilot Backlog") AND "AI Discipline" in ("Machine Learning (ML)", "Natural Language Processing (NLP)") AND "Current Status" in ("On Track", "Potential to Miss Target", "Behind Schedule", Completed, "On Hold", Blocked) AND "Initiative Type" = Pilot AND Platform in (OSDS, "Digital Reasoning", Platform, Quantifind) AND assignee not in (william.doscher)

Ankit Mathur

Hi Scott,

Correct me if I am not understanding your issue.

I am guessing you have a main task called "Initiatives" and it may have subtasks.

1) Is the issue type of those subtasks "Sub-task"?
2) Does your sub-task follow the same filter logic that you would have for the JQL you have mentioned?

If so, you can simply include "issue type" in "sub-task" within the JQL.

If not you can acheive this by either
1) Eazy BI
2) You can download the JQL results in an excel. You need subtasks associated with these. So you need a list of all sub-tasks in an excel (get that using a JQL) and then simply apply a v-lookup. You will need to lookup the "parent issue id" within the sub-task against the "issue id" of the parent task excel sheet.

Hopefully this helps.

-Ankit