Display stories sub-tasks using JQL when story has a custom field which is not available in sub-task

[Felix]

Hello, 

The situation is as follows: Our stories have a custom field which is used for labeling, lets call it "Custom_label". This field is not available in the sub-tasks of a story. 

What I want to do: I want to create a JQL statement which shows only stories (and their sub-tasks) with a certain value in the field "Custom_label". I'm able to create a statement which shows all the stories, but than the sub-tasks are not shown on the board. 

Is there a way to include the sub-tasks of a story in a JQL statement? If I need to install a plugin, is there a free one available? 

I'm using JIRA 6.3.15 with the Greenhopper plugin. 

I'm looking forward to your replies  

[SanaS]

Hi,

Scriptrunner is free for JIRA 6 (costs money from JIRA 7), and you will need it if you want the subtasks of those stories. 

you need something like this:

issuetype = story and custom_label = value OR issueFunction in subtasksOf("issuetype = story and custom_label = value")