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

Need to find all open Bugs and User Stories under closed/rejected Epics.

Gregory Kremer_mx3rfi

Hello everybody,

Need your help on writing ScriptRunner query with the the following requirements:

I need to find all Epics with Status Done or Rejected that have Open (not Done) Bugs or User Stories.

Readily admit that scripting is not my strongest suite, thus will greatly appreciate any help I could get.

Accepted answers

Trudy P Claspill

Not the right answer. Misread original post. This gets child issues based on a filter for Epics. Poster asked for Epics based on filter for child issues. That answer is supplied later in this Answer thread.

Hello @Gregory Kremer

You can do that using the ScriptRunner Enhanced Search option under the Apps menu.

This is the function you need:

https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-enhanced-search/jql-functions

issueFunction in issuesInEpics("project = <yourProject> AND status in (Done,Rejected)") and issueType in (Bug, "User Story") and statusCategory != Done

Breaking this down...

1. This part says which Epics you want to select

("project = <yourProject> AND status in (Done,Rejected)")

2. This part says get all the child issues of these Epics

issueFunction in issuesInEpics

3. This part says of those child issues, get just the ones that are Bug or User Story issue type and have a Status that is not in the "Done" Status Category.

and issueType in (Bug, "User Story") and statusCategory != Done

Karim ABO HASHISH

Hi @Gregory Kremer,

You may use the below query (replace the bold text with your project key)

status != Done and type in (bug,story) and issueFunction in issuesInEpics("project = yourprojectkey AND status in (Done, rejected)")

Cheers,

Karim

All comments

Trudy P Claspill

Hello @Gregory Kremer

You can do that using the ScriptRunner Enhanced Search option under the Apps menu.

This is the function you need:

https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-enhanced-search/jql-functions

issueFunction in issuesInEpics("project = <yourProject> AND status in (Done,Rejected)") and issueType in (Bug, "User Story") and statusCategory != Done

Breaking this down...

1. This part says which Epics you want to select

("project = <yourProject> AND status in (Done,Rejected)")

2. This part says get all the child issues of these Epics

issueFunction in issuesInEpics

3. This part says of those child issues, get just the ones that are Bug or User Story issue type and have a Status that is not in the "Done" Status Category.

and issueType in (Bug, "User Story") and statusCategory != Done

Karim ABO HASHISH

Hi @Gregory Kremer,

You may use the below query (replace the bold text with your project key)

status != Done and type in (bug,story) and issueFunction in issuesInEpics("project = yourprojectkey AND status in (Done, rejected)")

Cheers,

Karim

Gregory Kremer_mx3rfi

@Karim ABO HASHISH Thank you so much. Appreciate your help.

Gregory Kremer_mx3rfi

@Trudy P Claspill Thank you so much. I greatly appreciate your help.

Gregory Kremer_mx3rfi

@Trudy P Claspill Sorry, one more favore. Could you please please let me know how the query would look like if I wanted to list all Done, Rejected Epics with not completed Bugs and User Stories? I'd greatly appreciate it.

Gregory Kremer_mx3rfi

@Karim ABO HASHISH Sorry, one more favore. Could you please please let me know how the query would look like if I wanted to list all Done, Rejected Epics with not completed Bugs and User Stories? I'd greatly appreciate it.

Trudy P Claspill

The query already does that with part 3 mentioned in my previous reply.

If that is not the result you are seeing, please show us your query and an example of an issue that is in the results that you don't want in your results.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud