You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I need help to filter in a way that returns Issues under a list of Epics (I've already defined the list of Epics using a Filter).
So, the structure of my project is as follows:
Each Epic has two custom fields - Theme (Checkbox) and Business Line (Dropdown). They're assigned as below:
I can filter for BL1, which returns Epic 1, Epic 2, and Epic 3. Similarly, I can filter for Theme 2, which returns Epic 2 and Epic 4. What I'm struggling with is finding a way of returning corresponding Issues. I want to filter so that for BL1, I can show Issues 1-6, and for Theme 2, I want to show Issues 4, 5, and 7. Is there a way of doing this?
I have already considered using ParentEpic, which didn't work (it's a team-managed rather than admin-managed project). Any thoughts?
ps: please ignore my name - this is a company account, and not affiliated with the Jira mgt team in any way, shape or form!
Welcome to the community !!
As an alternative, you can try out our app:
The app is very flexible and you can use custom JQL for top level issues and a different JQL for child issues. I believe this will help meet your use case.
The app is free upto 10 users. Do try it out.
Disclaimer : I am part of the team which developed this app
Hi @Management Team -- Welcome to the Atlassian Community!
You cannot perform a query like that with out-of-the-box JQL. (It is not a SQL, and does not have such features.)
Do you have any marketplace addons/apps which extend the features of JQL? If so, one of them may help.
If not, and you do not need a query like this often, you have a couple of options:
Thanks Bill... yeah, from browsing the other, similar comments, I thought it would be a tricky ask.
Browsed the marketplace apps, but nothing seemed like it would do the trick in the way I'm looking at.
The idea was to have it more dynamic - so task boards and backlogs can shift depending on which business line etc. we're talking to. Extracting and statically pulling the Epics doesn't solve our challenge... it looks like it'll have to remain unsolved and we'll work around for the time being.
Cheers for the help - appreciate it!