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; } } }

Filter not showing subtask - due date on story level

Norbert_ldoq3m

I have a filter that should simply give me only the stories without due date.

project = "xyz" AND type in (Story) and duedate is EMPTY

The result is correct but sub-tasks are not shown on the list.

When I change the to

project = "xyz" AND type in (Story, sub-task) and duedate is EMPTY

The filter is not working at all, even if I have no due date in neither story or sub-tasks.

How can I filter just on the story level? Means show me stories with no due date but ignore sub-tasks.

Thanks a lot

Accepted answers

Nic Brough -Adaptavist-

Welcome to the Atlassian Community!

Your first query makes sense, you're asking to see all the stories in the project with no due-date. It's not going to show you any sub-tasks because sub-tasks are not stories.

Can you explain "does not work" for the second query? I would expect that to return all stories and sub-tasks that do not have a due-date set. Is it not doing that?

All comments

Nic Brough -Adaptavist-

Welcome to the Atlassian Community!

Your first query makes sense, you're asking to see all the stories in the project with no due-date. It's not going to show you any sub-tasks because sub-tasks are not stories.

Can you explain "does not work" for the second query? I would expect that to return all stories and sub-tasks that do not have a due-date set. Is it not doing that?

Norbert_ldoq3m

Thank you for answering.

The desired outcome of the query:

Show all the stories without due date but at the same time show their sub-tasks (now I have subtask "0" which is not true, these stories have sub-tasks in many different statuses).

And show it regardless if any sub-task itself has any due date assigned or not.

Hope this described the issue better.

Regards

Marco Brundel

Hi @Norbert ,

I've you have the app scriptrunner in use you can try the following JQL:

type in (Story) and duedate is EMPTY OR issueFunction in subtasksOf("type in (Story) and duedate is EMPTY")

Regards, Marco

Nic Brough -Adaptavist-

Yep, you'll need Scriptrunner (or one of the other apps that can effectively nest searches) to do this. Thanks @Marco Brundel !

Norbert_ldoq3m

Thanks guys for answer, not sure if we use scriptrunner but will check it and test it.

EDIT: it worked perfectly, thanks!

Cheers

Welcome!

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

Quick Links

Find more posts tagged with

jira-software