How to query parent deliverables whose child issues are not in a certain status

Question

Our hierarchy is Initiative > Deliverable> epic > issue-level (story, maintenance, bug, etc) and we have script runner. I am trying to return all "in development" deliverables past their Target Dev Complete Date whose child issues are not in a QA status (i.e. Ready for QA, In Functionality Test, etc).

For example -- would the following be used in any part of the query?

issueFunction in issuesInEpics("status = 'ready for dev' or status="in dev'")

Trudy P Claspill · Answer

Hello @Mich Blas

Did the information I provided help you meet your requirement? If so, please consider clicking on the Accept Answer button to mark your Question as Solved.

If you have more questions about this topic, let us know.

Trudy P Claspill · Answer

Hello @Mich Blas

Welcome to the Atlassian community.

The issuesInEpics() function will give return to you a list of children of the Epics, where the Epics match the criteria in the parentheses. In the above case you would get Story, Maintenance, Bug, etc. issues that were children of Epics where the status of the Epic was "ready for dev" or "in dev"

Refer to this documentation:

https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-enhanced-search/scriptrunner-enhanced-search-jql-functions/links-and-relationships#issuesinepics

Did I understand correctly that your desire is to get a list of issues of type Deliverable?

Do you want to apply the Status check to the Epics (the child issues of Deliverables)?

If the answer to the above two question is Yes, then you need to use the parentsOf() function.

https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-enhanced-search/scriptrunner-enhanced-search-jql-functions/links-and-relationships#parentsof

issueFunction in parentsOf(" issuetype=Epic and status in('ready for dev','in dev') ")

That will first find all the Epics in either status 'ready for dev' or 'in dev'. It will then find all their direct parents (Deliverables) and return the list of Deliverables issues to you.