Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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.

2 answers

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?

Hi @Trudy 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

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.

Like Richard Kallas likes this

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")

Daniel Ebers Community Leader Mar 23, 2021

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 ;)

0 votes
Daniel Ebers Community Leader Mar 23, 2021

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

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.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Marketplace Apps & Integrations

Bitbucket Smart Commits vs. Genius Commits - What's the difference?

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

106 views 0 2
Read article

Community Events

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

Events near you