...that epic has a particular label?
Hello and welcome to the community.
You can try the following JQL in your advanced search.
epiclink = "XXX" and assignee = currentUser() and labels = "XYZ"
Or if you are looking for any epic that is labelled and assigned to the current user, you can do the following:
epiclink is not empty and assignee = currentUser() and labels = "XYZ"
The next step is saving the JQL to create a filter that you can reference later on in other areas of the application.
If you can share more information on your use case than I might be able to provide further assistance. But I hope these options help get you started on your final JQL.
Doesn't seem to do what I would like.
Use case:
We have epics that get tagged with a label "CapEx" so we can bill back to parent company. But only the epic gets the tag. Need to be able to see our individual issues that are tied to an epic with that label so we can add time. Right now we have to go to the issue, click the epic link to find out if it is tagged CapEx. So the filter would just show my issues with it's parent epic that has that tag.
Does that make sense? Does in my head. lol.
Thanks
Thank you for the additional information. Are you using any plugins like Scriptrunner?
Hi @Derek Bowes
You cannot perform a nested query like that with out-of-the-box JQL. It is not a SQL and so doesn't have that feature.
If you need to do this type of query often please investigate one of the marketplace addon apps to enhance the features of JQL.
If you need to do this one time, you could first query to find the relevant Epics, grab their keys, parse them into a comma-separated values list, and then search for the linked issues with Epic Link.
Kind regards,Bill
We are not
just for a completely different direction: Is it a hard requirement for you to create this as a filter / JQL statement, or would it be okay to see these issues in some other form of list or table view? Because if that's the case, there would be a number of apps in the Atlassian Marketplace that would at least get you very close: I'm pretty sure you could model this in Structure, and it would definitively work in JXL for Jira (the app that my team is working on). What these apps (and several others) do is that they perform specific logic to establish parent/child relationships, in ways that isn't possible in plain JQL.
If this is an option, I'm happy to elaborate on how this could work on JXL, and I'm sure people could speak for other apps, too.
Hope this helps,
Best,
Hannes
It looks like you're new here. Sign in or register to get started.