nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Stories not closed that is included in an 'EPIC' with his 'stories' and 'spikes' closed

Richard Kallas

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?

SUMMARY:
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.

Accepted answers

All comments

Trudy P Claspill

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?

Richard Kallas

Hi @Trudy P Claspill

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.

Thanks

Daniel Ebers

Hi @Richard Kallas

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?

Regards,
Daniel

Richard Kallas

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.

Trudy P Claspill

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.

Richard Kallas

Thanks @Trudy P 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")