I need a query that extracts the following information:
Anyone could help writting the query in JQL? Many thanks
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:
Don't hesitate to reach out to us directly, if you have questions or feedback about our app.
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!