Jql to check issues that have "Start Date" < Today and all linked defects to it are closed

Mohamed Eltaweel

Hi,

What is the proper JQL for each of the following cases using the native Jira function or  using any other addon function

 - "Start Date" < Today and the issue still waiting for approval and all linked defects to it are closed

 

 - "Start Date" < Today and all linked defects to it are closed

 

Thanks

 

Jack Nolddor [Sweet Bananas]

Hi Mohamed,

Sadly, you cannot achieve the desired search using standard features on Jira. For this requirement you must go for a third-party app instead. Using i.e. JQL Booster Pack you can type the following:

 

1) "Start Date" < Today and the issue still waiting for approval and all linked defects to it are closed

"Start Date" < startOfDay() AND approval = pending() AND issue IN linkedIssuesOf(' type = Defect and status = Closed ') AND issue NOT IN linkedIssuesOf(' type = Defect and status != Closed ')

 

2) "Start Date" < Today and all linked defects to it are closed

"Start Date" < startOfDay() AND issue IN linkedIssuesOf(' type = Defect and status = Closed ') AND issue NOT IN linkedIssuesOf(' type = Defect and status != Closed ')

 

(*) Note that this is just an example, you must tune above query to fit your needs.

 

Using this app you can also query other issues relations, check:

• epicsOf()
• hasSubtasks()
• issuesInEpics()
• linkedIssuesOf()
• parentsOf()
• portfolioChildOf()
• portfolioParentOf()
• subtasksOf()

 

References:

• Official documentation

 

Hope this helps you to create awesome queries