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 want to get all issues which hasn't their delivered by Epic in the status New.
I built this JQL:
project = SFCR AND component = DMS AND status = Open AND "Epic Link" not in (status != New)
but getting this error:
Hi @Kaan Coskun
just to expand on @Craig Nodwell's great answer:
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.
A few directions forward:
If you want to run your search dynamically, without manually stitching two queries together, you'll need extra tooling:
Hope this helps,
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:
(I'm using epic status "To do" here but it would work the same with "New".)
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!
Out of the box jira won't give you those details. Do you have any add-ons that provide issue functions for jql queries. re: scriptrunner
The below example is using an issuefunction provided from the scriptrunner add-on.
issueFunction in issuesInEpics("project = SFCR AND component = DMS AND \"Epic Status\" != New")