How to create a filter where it returns all sub-tasks that a parent story has xyz

[Emily Mason]

This is what I am trying to create a filter for:

1. Project = X
2. Story has a field Y with value of "US"
3. In the board, I would like a filter that returns all sub-tasks with a parent story that has #2 above. 

Work around is I put "US" in all the sub-tasks but I want to avoid that and pull based on stories that have "US" in them.

Thanks! 

[Gustavo Félix]

Hi @Emily Mason 
If you have scriptrunner, you could use "subtasksOf" in your jql.
https://scriptrunner-docs.connect.adaptavist.com/jiracloud/enhanced-search.html#_subtasks

e.g.

issueFunction in subtasksOf("project=XXXX and yourField = XXX ") 

That jql returns the subtasks.

[Emily Mason]

Thank you. Is there a way to do this without script runner?

[Gustavo Félix]

Not to my knowledge.
There are others plugins of course, but I dont think is doable without one.

[Emily Mason]

thank you. I installed script runner. 

The JQL query I used is:

issueFunction in subtasksOf("Project = S2AGT and Service Provider-BI = US")

But I got this error:

• Error in scripted function: subtasksOf, see below
• Error in the JQL Query: Expecting operator but got 'Provider-BI'. The valid operators are '=', '!=', '<', '>', '<=', '>=', '~', '!~', 'IN', 'NOT IN', 'IS' and 'IS NOT'. (line 1, character 29)

The parent story has service provider-BI = US populated and I want to pull the sub-tasks that contain this US value in the story. The sub-task doesn't have US populated so trying to avoid populating the US to all sub-tasks. 

[Gustavo Félix]

I think the problem is that you have to put inside ' ' your custom field. 
Any of this two options should work.

1)issueFunction in subtasksOf("Project = S2AGT and 'Service Provider-BI' = US")
2)issueFunction in subtasksOf("Project = S2AGT and 'Service Provider-BI' ~ US")

[Emily Mason]

The second one did the trick Gustavo. Thank you so much for saving me hours to look into a solution. Have a great day!

[Gustavo Félix]

No problem, have a nice day

[pargab sala]

script runner is helpful here