How to write a query for the following situation:
I have project A, with many stories. Some of the stories have epic links to epics in projects B, C, D…..
What I need is an overview of all epics, from all projects, where project A stories are connected
Suggestions more than welcome
What do you mean by "an overview of all epics"?
If you only need some basic counts, you could create a simple filter, save it, and then show it on a dashboard with the two-dimensional filter gadget. Such a filter could be:
project = myProject_A AND "Epic Link" IS NOT EMPTY
Please add more criteria, as needed.
I had difficulty stating exactely what I need. Later I found a topic with more or less the same question, so hopefully this explain better what I need.
What I mean is : im trying to find in JQL all Epics, accross all projects, that one of his children are in the same project as Im woking on
My Project = a.
Epic = a1
Children of a1 : Story = a2, Story = a5, story b3
result: I want epic a1 selected.
My Project = a
Another project =b
Epic = b1
Children of b1 : Story = a2, Story = b5, story b3
result: I want epic b1 selected.
My Project = a
Another project =c
Epic = c1
Children of c1 : Story = c2, Story = c5, story b3
result: I don't want epic c1 selected.
In the end I will use this selection in a board, so I can see where my team is involved across all projects in my organisation.
@Daan Boesjes thanks for clarifying!
With out-of-the-box JQL you cannot create a query like that. (JQL isn't a full SQL.) You would need to purchase a marketplace addon to build that query for a board. There may be free addons which can do this, also found in the marketplace.
If you are unable to purchase/use an addon, an elaborate work-around could be:
I haven't tried this, and I expect it will work to dynamically update the filter of epics on the board.
For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events