How can i search for all the subtasks that have a specific filter on them?

[tayfun94]

Hello. I am trying to learn jql and at the company where I am working at the moment they have installed this plugin https://addonrock.atlassian.net/wiki/spaces/KB/pages/557163/JQL+Functions

In order to improve our flow we created a kanban where we post our issues and take from them to solve. For our QA team we have a column ready to test where it checks for sub tasks that have the done status in order for them to start retesting and finalise the flow to make the issues "Completed".

We are working with parent issues that have a label and in order for a task to appear as "Ready for testing", we need to put that label also on the sub task.

How can i search for all the issues that have the label on the parent but not on the sub task?

Our parents are Development and the subtasks are simply Development Subtask

I tried something like this to search for my search but it doesn't work with the not condition. I even deleted the label from one the subtasks to test but it doesn't work.

issuetype = "Development Subtask" and issue in havingParentIssuesFromQuery("labels = myLabel") and labels != myLabel

Thank you and sorry for my stupid question :(

[Tarun Sapra · Accepted solution]

Hello @tayfun94 

Try this

"How can i search for all the issues that have the label on the parent but not on the sub task?"

issue in subtaskIssuesFromQuery("labels = myLabel") and type = "Development Subtask"  and (labels is EMPTY or labels != myLabel) 

[tayfun94]

It worked. @Tarun Sapra  you're a genius. Thank you very much.