Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Scott Federman
Contributor
March 26, 2019

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)

1 answer

0 votes
Ankit Mathur April 3, 2019

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events