JQL & Google Sheets - Not Listing All Subtasks

Question

Hello,

I have a bit of a conundrum I'm hoping to get a hand with. I'm using Jira Cloud for Sheets and have successfully imported several issues to a google sheet. However, I noticed that not all the subtasks are importing for some reason. I expect that it's because I'm not using the correct JQL as I'm a bit new with it, but I'm not sure what to change in my syntax.

I'm simply trying to call each sub-issue under one issue in a project. Here's what I'm currently using:

=JIRA("project = MYPROJ AND 'Epic Link'= XXXX-3641 OR (issuetype = sub-task AND 'parent' IN (XXXX-3641))", "summary, status", 0, 10)

If there's a simpler way to just get a list of every sub-issue grouped under an issue I'm all for it. Thanks in advance for any help!

Rena Lourie · Answer

Hi there, thanks Jens,

For some reason even using this query does not fix the problem, and I'm not sure why. I was able to pull everything I need by calling the entire Epic, but for whatever reason when I attempt to look for the entire sub-task list within a task, I was still missing some sub-tasks. Any ideas would be appreciated!

Jens Schumacher - Released_so · Answer

Hi Rena,

Take a look at this thread: https://community.atlassian.com/t5/Jira-Software-questions/JQL-to-show-all-issues-and-subtasks-in-an-epic/qaq-p/1432325

The thread outlines how to get all subtasks in "Team Managed" and "Company Managed" projects.

This seems to be the best answer in the thread.

parentEpic in (EPIC-1, EPIC-2)

Hope this helps,

Cheers,
Jens

Released.so - Release notes powered by Jira