How to retrieve subtasks where the parent task is in a specific status

[Deleted user]

As we can't use JQL Tricks in OnDemand to do --issue in parent("status != Open") -- how else can we retrieve just the subtasks where the parent task is in a specific status?

[Tamir Lavi]

Hi guys.

I think I have a workaround.
Using Scripted Field (I named is parentStatus)
And this code as the script:

import com.atlassian.jira.issue.Issue

Issue pi = issue.getParentObject()
if (pi == null) return null

return pi.getStatusObject().getSimpleStatus().getName()

I hope it helps anyone.

[Bastiaan Jansen]

I'll paste the response from the support case:

it is not possible at this time to perform this through JQL (with the build-in options) Please see the following improvement request for our Jira product here
As you already mentioned it is also not possible to install additional plugins to the OnDemand environment, there is an open improvement request to bundle this specific plugin in future requests. I would like to als you to vote on the request here

[Ben Thompson]

I'd like to know how to do this to. On a kanban board I need to display only the tickets whose parents' status is of a particular value. Without this, I'm struggling to find a workaround and I'd really not 'bodge' it already this early in our adoption of Jira.