Show all sub-tasks for a specific Issue Type

[Nick Wheeler]

Hi,

I am trying to write a basic JQL query to show all sub-tasks under a particular issue type. Been trying to work it out by googling, but not managing. So far I have ...

project="Operational ERP" AND issuetype=Sub-task AND issue in parent("issuetype=story")

I am using a custom issue type, not Story, but changed to align to a standard type for testing.

Please note

• Needs to work on Jira Cloud
• Want to do with standard JQL query and not install an add-in to achieve the required result

Thanks in advance for any help!!

Nick

[Muhammad Ramzan_Atlassian Certified Master_ · Accepted solution]

You cannot achieve this without using a third party plugin. I can suggest you ScriptRunner or  JQL Search Extensions for Jira & reports 

Scriptrunner is more expensive than JQL Search Extensions for Jira & reports  after 25 users.

Here is the example how to get all sub tasks belongs to issue type story using  JQL Search Extensions for Jira & reports 

issue in subtaskOf("type= Story")

[varun_kumar]

I guess  following would be enough to get all the sub tasks of a story

parent = PC-XXXX ORDER BY status DESC, rank

[Mystic Lin]

Try this:

issueFunction in subtasksOf("\"Type\"=Story")

[Mariana_Pryshliak_Saasjet]

Hello @Nick Wheeler 

You can find an answer to your question in this discussion:

https://community.atlassian.com/t5/Advanced-Roadmaps-questions/How-can-I-filter-for-sub-tasks-of-a-specific-issue-type/qaq-p/1333444

I hope it helps.

Best regards, Mariana

[Nick Wheeler]

Thanks - so you can't do it without an add-on?

[Mystic Lin]

issueFunction in subtasksOf("\"Type\"=Story")

It works for me. 

[Lara Krefski]

@Mystic Lin Isn't subtasksOf only available through use of a plugin?

[Mystic Lin]

Indeed, I think that's a feature of ScriptRunner.

[Angie Affolter]

issueFunction in subtasksOf("\"Type\"=Story")

That works for single named issue types, but how do I specifiy an issue type that's two words??  I've tried everything I can think of and it's not working.  

[Muhi Khair]

Does it work on cloud: 

issueFunction in subtasksOf("\"Type\"=Story")

I get this message in Cloud

The "subtasksOf" JQL function provided by "Adaptavist Scriptrunner" for Jira Server works differently in Jira Cloud. Run it directly in "Enhanced Search" instead. See the documentation for more details: https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-jql-keywords-functions 

and the link doesn't work