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

Question

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 · Answer

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")