ADVANCED FILTER EPIC

[Pedro Ramos]

I need a query that extracts the following information:

• Issue type: Story.
• Issue status: TEST
• Status of the Epic Link: TESTS 

Anyone could help writting the query in JQL? Many thanks

[Marlene Kegel - codefortynine]

Welcome to the community, @Pedro Ramos.

I am Marlene from codefortynine.

Another option would be Dynamic Custom Fields for Jira.

With our app you can display the status of the parent issue within a story or any other issue type. 

Our app works with Jira Expressions, but we offer a template to display the "Parent status", so you don't need any experience with Jira Expressions in order to work with our app. 

Once the field is available for your issues, you can use it for JQL and your issue statistics. 

issuetype = story AND status = "test" AND "Parent status" = "test"

This is how you set up a Dynamic Custom Field. After installation you simply:

• Navigate to the Dynamic Custom Fields configuration
• Create a new Dynamic Custom Field by selecting the template "parent status"
• Add the field to the desired project/issue type

Don't hesitate to reach out to us directly, if you have questions or feedback about our app.

[mauricio.groth]

Hi @Pedro Ramos 

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 your children stories, that are in Test status, and the epic Parent is in the status TESTS

issue in childrenOfEpicsInQuery("status = TESTS”) and issuetype = Story and status = TEST

 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

[Mathias Richter]

Hi @Pedro Ramos 

filtering the parent Epics first and get query results based on such a sub-query requires an additional plugin. Examples can be found in the Marketplace, e.g. by searching for JQL as keyword.