JQL - Only show parents and subtasks until both are "Complete"

Question

I have a request from a team at my company to make an edit to their Jira board. They have Parent Issues which have subtasks. They would like to see everything on this board, however, when a parent issue is complete (in a 'Ready for Testing' status) and all of the subtasks are complete, to hide them from the board. Essentially I need to hide subtasks if they are complete and then also hide the parent issue from the board if all the subtasks are complete and the Parent issue status is 'Ready for Testing'.

Any JQL wizards out there have an idea how I can accomplish this? Any help is appreciated.

Thanks!

-Curtis

Curtis Freudigmann · Answer

Thank you for your response @Tarun Sapra ,

I am currently using Script runner and I have been testing out the parentOf function. The issue I am having is I want to show the parent issue on the board if it's in the Ready for Testing status until all subtasks of that parent are in Complete. At which point both the parent and the subtasks should be hidden from view.

I have been using the quick filters to test out my JQL but this will be the general filter on the board once I get it how I want.

The other requirements I have for this board is that it needs to show all other statuses and issues/issue types except for what I outlined previously.

Any other assistance would be greatly appreciated.

Thanks again!

-Curtis

Tarun Sapra · Answer

Hello @Curtis Freudigmann

Either you modify the underlying JQL filter for the board to remove sub-tasks which are done, or you can add a "Quick filter" on the board which can hide done sub-tasks from the board when user clicks on the Quick filter.

You would need to use a paid plugin for JQL ( I generally use Script runner) but there are others as well on the marketplace.

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_parentsof

In your case the JQL would be something like

issueFunction in parentsOf("resolution is not empty") and status = "Ready for Testing"