JQL query that returns parent tickets that have an associated sub task in particular status

[Mark]

Hi guys,
I am trying to write a quick filter for my Jira KANBAN board that returns all tickets that have an associated sub-task in the In-Progress status. Is it possible to do this without scriptrunner? What functions can I use to return these parent tickets?

Thank you!

[John Funk]

Hi Mark - Welcome to the Atlassian Community!

Just write a query/filter like: project = ABC and issuetype = Sub-task and status = "In Progress"

Then just add the Parent field as a column in your results.