nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to get all issues without an epic and their subtasks?

Victoria Luskin

Hello,

How to get all issues without epics and their subtasks? I tried the following JQL, but it fetches all subtasks from the project (even if they linked to the irrelevant story).

type != Epic AND "Epic Link" is EMPTY

If I try to exclude these subtasks, I cannot see subtasks at all in the output list:

type not in ("Epic","Sub-tasks") AND "Epic Link" is EMPTY

Thanks,

Accepted answers

Trudy P Claspill

Hello @Victoria Luskin

Are you working with Jira Cloud or Jira Server/Data Center? If your URL is like the following then you are working with Jira Cloud.

https://<something>.atlassian.net

If you are working with Jira Cloud, are you trying to get issues from Company Managed projects or Team Managed projects or both?

I understand you want to get a list of standard issues and their subtasks. Is it also true that you want only the standard issues that are not children of Epics?

To get the subtasks of a list of standard issues use this:

linkedissues in (<comma separated list of standard issues>) and issuetype in subtaskIssueTypes()

You have to use an explicit list of issue keys for the standard issues in the above statement. Jira does not have a native method to let you provide that list dynamically for the linkedissues keyword.

There are third party apps that would allow you to get the subtasks for a list of standard issues where the list of standard issues is derived dynamically from another JQL statement.

Do you have any such third party apps, or would you consider acquiring one?

All comments

Trudy P Claspill

Hello @Victoria Luskin

Are you working with Jira Cloud or Jira Server/Data Center? If your URL is like the following then you are working with Jira Cloud.

https://<something>.atlassian.net

If you are working with Jira Cloud, are you trying to get issues from Company Managed projects or Team Managed projects or both?

I understand you want to get a list of standard issues and their subtasks. Is it also true that you want only the standard issues that are not children of Epics?

To get the subtasks of a list of standard issues use this:

linkedissues in (<comma separated list of standard issues>) and issuetype in subtaskIssueTypes()

There are third party apps that would allow you to get the subtasks for a list of standard issues where the list of standard issues is derived dynamically from another JQL statement.

Do you have any such third party apps, or would you consider acquiring one?

Victoria Luskin

Hello @Trudy P Claspill

Thanks for your assistance.

I am working on Server/Data center.

You got it correct, I need to get the list of all items without Epic and if those items have subtasks, I want to display them as well.

I have tried to use JQL you suggested, but it doesn't work for me.

Now I am trying this way: to show all items, except Epic & Subtasks OR all subtasks from the stories without Epics, but the list does not include subtasks at all. Can you please take a look?

(project = RAIN) AND (type not in (Epic,Sub-task) AND "Epic Link" is EMPTY) OR (filter ="Story without Epic" OR (issueFunction in subtasksOf("filter = 'Story without Epic' ")))

Thank you

Trudy P Claspill

Hello @Victoria Luskin

For future posts you might want to make sure that you tag your post to identify your hosting type and specify the version of the product you are using. That will help us direct you to the correct answer/documentation more quickly.

There was a typo in the JQL I provided to you. It should be linkedIssue (singular) rather than linkedIssues (plural).

Regardless, I see that you have "issueFunction" in the new filter that you tried, which indicates you have a third party app that extends the JQL functionality with additional functions.

If you create and save a filter for stories without epics thus:

project = X and issuetype not in (Epic, subtaskIssueTypes()) and "Epic Link" is empty

Then you can get the standard tasks and their sub-tasks thus:

filter = "Stories without Epics" or issueFunction in subtasksOf("filter = 'Stories without Epics'")

Victoria Luskin

@Trudy P Claspill Thanks a lot for guiding me. It works!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira