Filter not showing subtask - due date on story level

[Norbert]

Hi

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

[Nic Brough -Adaptavist- · Accepted solution]

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]

Hi

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]

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

EDIT: it worked perfectly, thanks!

Cheers