Hey everyone, hope you are all doing well!
Sorry about the poor title up there, but my characters are limited there.
Let me try to explain it better...
Well, I'd like to know if it's possible to check if any of the Epics whose stories are in my current sprint have the Assignee filter empty, but again I only care if its empty if there is a story associated to that Epic in my current sprint.
Example:
I have 3 Epics - Epic 1, Epic 2 and Epic 3.
In my current sprint I have 5 stories (A, B, C, D, E) - 3 of them (A, B, C) associated with Epic 1 and 2 of them (D, E) associated with Epic 2 and none associated with Epic 3.
Epic 1 properly has the field Assignee filled, however, Epic 2 and 3 have this field empty.
I currently do not care about Epic 3 not having an Assignee, because I don't have any stories associated to it in my current sprint, however, Epic 2 has story D and E associated to it, so I care.
Is there a JQL I can use to filter and find the Empty Assignee field from Epic 2 based on D and E stories on my current sprint? Or basing it on anything else?
*Note: We currently do not want to indicate Sprints in Epic issues.
Sorry if it was confusing, but it's quite difficult even to explain :S
Unfortunately, this is trickier than one might think; as a hierarchical query, it would really require some kind of "join" or "subquery", which isn't available in plain Jira/JQL.
I'm afraid you'll need some additional tooling for this.
Hope this helps,
Best,
Hannes
Just to expand on the last point, this is how this would look in the app that my team and I are working on, JXL for Jira. Put simply, you'd create a sheet with all issues that are potentially relevant to you, enable the default issue hierarchy (that's just one click), and then use JXL filtering capabilities to narrow down to the issues that you care about:
(This is showing all unassigned epics with children in sprint Fine sprint 1.)
Once you have your list of issues, you can work on these directly in JXL (much like you'd do in e.g. Excel or Google Sheets), trigger various operations in Jira, or export them for further processing.
Any questions just let me know!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello @Lucas Ferreira
Your explanation was quite thorough and clear, so you did great!
But do you know if you have any add-ons like scriptrunner etc available?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks @Kalyan Sattaluri !
I don't think we have... Is there any one you would recommend? Preferably free haha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.