Can we create a search filter extension to filter for the subtasks under the epic?

[Yi Voon Phan]

Hi, 

Could we filter the subtasks which is not done under the epics?

I have tried to use below:

1. Below extension is trying to find the subtask which is still in the status of "created".

issuetype = Epic AND status is not EMPTY AND status = created AND subTaskStatus is not EMPTY AND subTaskStatusCategory = "TO DO"

2. Below extension is trying to find the subtask which is still in the status of "in progress".

issuetype = Epic AND status is not EMPTY AND status = created AND subTaskStatus is not EMPTY AND subTaskStatusCategory = "In Progress"

Question: Above extensions filtered out the subtask which is still in the status of "created' and "in progress". Could we have a JQL extension which can filter out all which is in the status of "created and "in progress" with only one JQL search extension and not both of the above (1) and (2)?

[Andy Nguyen · Accepted solution]

Hey Yi Voon,

Does subTaskStatusCategory come from an add-on?

Assuming that it works, you may use this JQL:

issuetype = Epic AND status = created AND subTaskStatusCategory in ("TO DO", "In Progress")

In my opinion, "status is not EMPTY" is not necessary, as status can't be empty. Similarly, subTaskStatus, if it exists and works, can't be empty.

Cheers,

Andy

[Yi Voon Phan]

Hi @Andy Nguyen,

Thanks for your guidance. Appreciate it and it is helpful.

Would you mind if you can help on the below question as well? Thanks in advance. 

https://community.atlassian.com/t5/Jira-Service-Desk-questions/How-to-get-the-setup-completed/qaq-p/863542

[Andy Nguyen]

Nice to hear that Yi Voon,

Would you mind accepting my answer by clicking the button on the left of the Vote button!

Thanks,

Andy