I need JQL query for below:
I would lead you to an answer I gave in the past: https://community.atlassian.com/t5/Jira-questions/Show-list-of-linked-issues-from-a-number-of-issues/qaq-p/273189
These variations will help you get the data you want.
If you just want to find story, bugs etc connected to Epic then you should use
"Epic Link" = <epic-issue-key>
But if you want to list also the sub-tasks of the stories/bugs etc that are connected to epic then it's not possible to do that in default Jira. You need a plugin. If you have portfolio plugin then you can do
issuekey in childIssuesOf("ABC-34")
Here ABC-24 is the epic key and this will list all the child issues of epic and the sub-tasks of the child issues as well.
I have list of 100 epics and it's associated issues(User Story, Bugs etc.) in my Project's backlog.
Now I want to display only 15 epics and it's associated issues(User Stories, Bugs, etc.) on my Team's Scrum board Backlog.
For example: Out of 100 epics, I want to use E1, E2, E3, E4----E10 and display it's associated issues like US1, US2---US10, Bug1, Bug2--Bug10 on my Team's Scrum board backlog.
Current Query I'm using for my board is as below:
project = TP AND "Epic Link" in (E1, E2, E3, E4, E5, E6, E7, E8, E9, E10) OR id in (E1, E2, E3, E4, E5, E6, E7, E8, E9, E10) ORDER BY Rank ASC
Problem: This query is working for me and giving all the child issue types associated with the aforementioned epics. But in future the size of this query will grow by adding every time a new epic is introduced.
So can anyone please suggest how can I narrow down this growing query size ?
1)Scenario 1 : without a plug-in
2)Scenario 2: with a plug-in
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