How to get sub-tasks based on story field selection?

[Patrick Sittinger]

I want to get all sub-tasks where the related stories have a field set to a special value. I would describe it as a kind of sub query. Something like that: type = story and parent in (type = story and status = in progress)

[Jobin Kuruvilla [Adaptavist] · Accepted solution]

JQL Tricks plugin (commercial) supports the same, with a lot of other useful functions.