I need help writing a JQL for a 'quick filter' that returns:
STORY (not closed, so in any other status) that is linked to an OPENED EPIC where the rest of the issues (only for stories and spikes) are closed.
I tried with this JQL, but it doesn't run:
project in(project-AAA, project-BBB) AND issuetype in (Story) AND status != Closed AND issueFunction in linkedIssuesOf(" issuetype in (Story,Spike) AND status = Closed", "has epic")
Can someone help?
Show: STORY in status not closed ---> issuetype in (Story) AND status != Closed
Environment: In his EPIC, all 'stories' and 'spikes' are closed, except the STORY that we search because it still not closed.
Hello @Richard Kallas
Welcome to the community.
Are you working with JIRA Cloud or with JIRA Server (or Data Center)?
When you say the story is "linked to" an open Epic, are you talking about the generic issue linking or do you mean the Story is a child issue of an open Epic?
Uf! I'm not a specialist in JIRA. I think that JIRA Server (or Data Center).
Using "Linked to" I want to say "Issues in Epic"
So, an EPIC can contain several issues inside as 'Story', 'Spike', 'Bugs'.
When all issues in the epic are closed, the EPIC could be closed, too.
I can see in Jira, a dashboard for a sprint, where I can see 'Stories' 'Spikes' or 'Bugs' in process.
I need a 'quick filter' to see any 'STORY' in the current sprint (story opened because is in progress) that the 'ISSUES IN EPIC' (according to the EPIC father) are closed.
For me, it is a radar to be aware that when that 'Story' (story filtered with the 'Quick filter') will close, the 'Epic' can be closed, too.
If the goal is to set the Epic to Closed when its last child issue is closed, you could do that with the automation feature.
As to whether you are using JIRA Cloud or JIRA Server, if the URL for your JIRA instance is something like https://<something>.atlassian.net, then you are using JIRA Cloud. Otherwise you are probably using JIRA Server or JIRA Data Center. The admins for your JIRA instance should be able to tell you. The types of hosting affect the functionality available out of the box, so that affects the recommendations the community might give you.
Thanks @Trudy Claspill , so it's JIRA Server or JIRA Data Center.
Mi goal is a 'Quick filter' for using in dashboard of sprint with 'Stories', 'bugs' and 'spikes'.
The condition is to be able to filter those 'Stories' not closed (issuetype: story and status! = Closed) when it is the last one left to close the EPIC.
In other words, an EPIC has already closed his 'stories', 'spike' and 'bugs', except the one that I want to filter on the dashboard because I want to have that visual alert.
If 'QUICK FILTER' shows a 'Story', should be because is the last issue opened and linked an Epic with other stories closed.
Similar to this one, but it doesn' run:
ISSUETYPE = story AND status !=Closed AND issueFunction in issuesInEpics("project in(AAA, BBB) and issuetype in(Story,Spike,Bug) and status !=Closed")
The function you are using is one from Script Runner. So the question is if it does not run because you do not habe the App - obvious case OR if you have it but assume you have not.
Is Jira autocompleting the function when you type issueFunction?
Other than that you could double check with your Admin. At least I can say having it would make life easier ;)
hoping to understand you right and assuming you have Script Runner installed a query like this could be the solution:
type= Story AND resolution IS NOT EMPTY AND Sprint IN openSprints() AND issueFunction IN issuesInEpics("project = DEMO AND resolution IS EMPTY")
Could you please check and confirm?
Hi @Daniel Ebers
I'm sorry, but I don't have 'Script Runner'.
I think that the query that I need is very complicated because anybody answered my request.
I am using another query, this one is not as accurate as what I needed, but it is working for me.
I guess it is difficult for the query to only show me the 'story' in current sprint [type= Story AND status !=Closed] if this story it is the only one that is still open at EPIC.
If you already heard about Smart Commits in Bitbucket, know that you just stumbled upon something even better (and smarter!): Genius Commits by Better DevOps Automation for Jira Data Center (+ Server...
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