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)
JQL Tricks plugin (commercial) supports the same, with a lot of other useful functions.
It looks like you're new here. Sign in or register to get started.