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

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

Accepted answers

All comments

Benjamin_tmh9yg

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

Trudy P 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 P 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

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

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud