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

Finding open issues with closed child tickets

C-Ramon.Alicea

I am trying to find all open issues within a certain state where they exceeded their due dates and that have all their child tickets closed. I have generated the following statement but keep getting results where a couple of the child tickets are still open:

project = PROJECT1 AND issuetype = "INTAKE Request" AND status = Initialization AND resolution = Unresolved AND issueFunction in linkedIssuesOf("status in (Closed, Completed, Cancelled)", "Dependency For", "relates to", "is related to") AND "Expected Completion Date" <= -1d

The goal is to identify open issues in the final status that have not been closed when all the child work (child tickets) are done.

Thank you in advance for any assistance.

Accepted answers

Laurie Sciutti

Hi @C-Ramon.Alicea and welcome to the Community! Try the following:

project = PROJECT1 AND issuetype = "INTAKE Request" AND status = Initialization AND resolution = Unresolved AND NOT issueFunction in linkedIssuesOf("statuscategory in ('To Do', 'In Progress')", "Dependency For", "relates to", "is related to") AND "Expected Completion Date" <= -1d

One thing to note though: if you are looking at child issues, I'm assuming you want to include a check of sub-tasks in your filter. If so, AND if you use ScriptRunner, you would want to include the following as an OR statement:

issueFunction in parentsOf("statuscategory not in ('To Do', 'In Progress')")

All comments

Laurie Sciutti

Hi @C-Ramon.Alicea and welcome to the Community! Try the following:

project = PROJECT1 AND issuetype = "INTAKE Request" AND status = Initialization AND resolution = Unresolved AND NOT issueFunction in linkedIssuesOf("statuscategory in ('To Do', 'In Progress')", "Dependency For", "relates to", "is related to") AND "Expected Completion Date" <= -1d

issueFunction in parentsOf("statuscategory not in ('To Do', 'In Progress')")

C-Ramon.Alicea

Hi @Laurie Sciutti

Thank you for your feedback. While I was able to get some response back from the statement, I am still receiving issues in the response that have either one (1) or two (2) linked tickets still opened. Additionally, to answer your previous question, I am using ScriptRunner. A little additional information to my situation. The child tickets are listed in the Issue Links section has either relates to, is related to, or a very rare Dependency For or Depends On. These child tickets belong to other business units’ projects.

Laurie Sciutti

@C-Ramon.Alicea ~ that's helpful. Of the ones that still appear in your query, are those "Depends On" linked type? Those weren't in your provided example above. If you adjusted your query to check for those? If you did, do you see any similarities in the ones still showing that shouldn't? Like, do they share they same link type?

C-Ramon.Alicea

@Laurie Sciutti

I found the link type “Depends On” from your query and adjusted the query to include it. I believe that I implemented your feedback correctly:

project = PROJECT1 AND issuetype = "INTAKE Request" AND status = Initialization AND resolution = Unresolved AND NOT issueFunction in linkedIssuesOfAll("statuscategory in ('To Do', 'In Progress')", "Dependency For", "relates to", "is related to", "Depends On") AND "Expected Completion Date" <= -1d OR project = PROJECT1 AND issuetype = "INTAKE Request" AND status = Initialization AND resolution = Unresolved AND NOT issueFunction in parentsOf("statuscategory not in ('To Do', 'In Progress')") AND "Expected Completion Date" <= -1d

The ones that appeared that are outside the goal the link types vary.

Welcome!

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

Quick Links

Find more posts tagged with

scriptrunner

jira

unknown-hosting-type

jira-software-unknown-hosting-type