Jira Filter with "parent in"

[Hansi]

Hello!

I want to create a filter for subtasks.

List all not closed Sub-Task of an project that belongs to a specified Filter.

The Subtasks:

project = ITSD AND issuetype = Sub-task AND status in ("In Progress", "To Do")

The Parent: 

project = ITSD AND issuetype = "Service Request" AND status in (Open, "in Arbeit", "Wartet auf Genehmigung", Auslieferung) AND (ITSD-Anfragetyp-Helper = "Server bestellen")

how can I do this?

I have tried something like this:

project = ITSD AND issuetype = Sub-task AND status in ("In Progress", "To Do") AND parent in childIssuesOf("project = ITSD AND issuetype = 'Service Request'")

I will get: Unable to find an issue with matching key project = ITSD AND issuetype = 'Service Request'

rg

hansi

[Thomas Schlegel · Accepted solution]

Hi Hansi,

do you have the Scriptrunner app? If so, you can do something like that:

project = ITSD AND issuetype = Sub-task AND status in ("In Progress", "To Do") AND issueFunction in subtasksOf("project = ITSD AND issuetype = 'Service Request' AND status in (Open, 'in Arbeit', 'Wartet auf Genehmigung', Auslieferung) AND (ITSD-Anfragetyp-Helper = '
'Server bestellen')")

[Thomas Schlegel]

with plain Jira, you can't have subqueries like in SQL

[Hansi]

Hello!

thank you for help! I got it.

rg

hansi

[Chandrakanth Gangaram]

Hi Hansi,

Can you please share how you had combined both the queries?

[Isaiah John]

Guys, I just learned you can use the "scheduled" trigger to do a JQL Query. All issues returned will be treated as trigger issues. You could then use the "For: Sub-tasks" branch then a status condition to act on their sub-tasks.

[Preethi Ramesh]

I was trying to exclude all subtasks from a specific parent key and used the below query. Worked for me. 

assignee in (<jira usernames>) AND status not in (Closed, Done, Complete, Resolved, Cancelled) AND project not in (<give project names that you would like to exclude>) AND  parent != <which ever parent key you would like to exclude> 

This query removed all the subtasks for the parent key

[Hansi]

thank you for answer!

yes Scriptrunner app is installed.

I will check next week on monday.

rg

hansi