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_ · Accepted solution]

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

[Mohamed Benziane]

Hi Mohamed,

You will need an addon like scriptrunner to achieve this.