JQL query that only includes results with a certain sub-task issuetype

[Deleted user]

Hello,

I need to include in the results of this JQL only sub-tasks for parent 'Service Request' that are of issuetype 'Build and Test' (so exclude all others for that parent issuetype). I've tried everything but I can't seem to figure it out. HELP! 

project = "XXXXX" AND status != Closed AND (issuetype = Incident AND "Cascading Select List 1" is EMPTY OR issuetype = Problem OR issuetype = "Service Request" AND "Activity Type for Service Request" in ("XX XX", "XX XX", "XX XX", "XX XX") OR issuetype = Enhancement AND "Activity Type for Enhancement" in ("XX XX", "XX XX") OR issueFunction in subtasksOf("issuetype = \"Service Request\" AND \"Activity Type for Service Request\" in (\"XX XX\", \"XX XX\", \"XX XX\", \"XX XX\") OR issuetype = Enhancement AND \"Activity Type for Enhancement\" in (\"XX XX\", \"XX XX\")")) AND "External Ticket ID" is EMPTY

Thank you!

[Alexander Pappert]

so you have more than 1 parent issue type, right?

then you could try this one https://community.atlassian.com/t5/Jira-questions/Filter-Subtasks-Where-Parent-Task-Is-a-Certain-Issue-Type/qaq-p/525337

https://marketplace.atlassian.com/apps/31399/jql-tricks-plugin?hosting=server&tab=pricing

or, as workaround

use automation or some other addon an copy the parent issue type into a new custom field in the subtask. Then you have JQL subtask issue type + CF.

[Deleted user]

Thank you Alexander! 🙃