Create a search filter/dashboard for issues and subtask

[vishalp1]

Hello 

I am trying to create a search filter and use it in dashboard. 

I am using search criteria using Epic name, issue type = story but not able to add filter clause for sub-task. There is no option to choose Sub-task as filter criteria in issue search

I wanted to pull list of stories where sub-task exists and their status 

Please assist.

I tried to look in previous posts but couldn't find any

[Benjamin]

HI @vishalp1 ,

Should be able to use a query like this.

Issuetype in (story, sub-task)

See example post below:

https://community.atlassian.com/t5/Jira-questions/I-am-looking-for-a-JQL-to-list-all-stories-and-subtasks-similar/qaq-p/1227382

Thanks,

Ben

[vishalp1]

Thanks for your response. The link shows how to display stories and sub-tasks in one search based on project.

I am trying to pull list of stories and add a filter in search criteria where sub-tasks are open but in filter criteria i dont see sub-task as seach field 

[mauricio.groth]

Hi @vishalp1 

As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

You can use this query to find all the stories that have subtasks in X status.

issue in parentsOfSubtasksInQuery("status = x") and type = Story

Check out the documentation for more examples.

If you have any other questions, please contact our support. We’ll be happy to help you!
Best regards,
Maurício

[Trudy Claspill]

Hello @vishalp1 

Can you provide a bit more information about the goal of your filter?

Are you trying to retrieve all Epics, Stories, and Sub-tasks?

Are you trying to filter for 1..n specific Epics, then only the child Stories in those Epics, and then only the Open Sub-tasks in those Stories?

If the latter, that is not possible with native Jira functionality. You will need a third party app to be able to create a subquery just for the Sub-tasks within the larger filter that also is retrieving Epics and Stories.

[vishalp1]

Sorry for late response.

Let me give an example:

I have list of user stories in 2 different epics for which i wanted to create a dashboard.

some user stories have sub task created and some may not. I wanted to pull dashboard showing list of user stories where sub-task exists and what status they are in

1. user story A - sub task a1 - status - To do

2. user story B - sub task b1 - status - complete

[Trudy Claspill]

Jira does not have native functionality for the query you want to build. It is not capable of a query that performs

For 2 specific Epics

Get the child stories of those Epics

and get the Sub-tasks of only those Stories.

You can find the natively available search functions here:

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/

There are other related pages that talk about other aspects of searching like keywords and operators.

To get wha you want you will need to have a third party app that extends the searching capabilities of Jira. There are several available in the Atlassian Marketplace.

https://marketplace.atlassian.com/search?hosting=cloud&product=jira&query=jql

[vishalp1]

Thanks for your response