Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to get all users story and sub-tasks under user story?

We want  to separate out some of users story / sub-tasks based on some fields in user story. 

Condition  - all user story and sub-tasks if project team = "adapter".

Please note we have project team field for user story only not for sub-tasks. Please provide any field we can write using script runner plugins to get above data. 


Raj Kumar

5 answers

1 accepted

3 votes
Answer accepted

Hi Raj,

The hasSubtasks() script JQL function provided by the ScriptRunner plugin would allow you to find out this information if you used it in a JQL query similar to the one below which shows all issues that are of type story and contain the value adapter in the project team field.

issuetype = Story and "project team" = adapter and issueFunction in hasSubtasks()

You can the configure the columns shown in the returned JQL query to show the subtasks column which will show all of the subtasks for each query as shown in the screenshot below.

image2016-3-23 10:53:10.png

This query could then be saved as a filter and placed in a filter results gadget in order to share it with other users on a dashboard.

I hope this helps.



Thanks. We are able to see the sub-tasks links but if we use the same field in Agile Scrum board unable to see the sub-tasks list like a normal board. See the attached screen shots for more information. 

Like Jose Cabrera likes this

Hi Raj,

Thankyou for your response. It looks as if you question is in fact related to how JIRA Agile (JIRA Software) displays fields on cards.

By design the cards in JIRA Agile can only show three fields but you can show the Sub Tasks field on a card as shown below.

image2016-3-23 11:8:50.png

I would look to implement the JQL query provided above as a quick filter or swimlane so that you could pull in all issues which are stories with the project team adapater and have sub tasks into a filter view or a seperate swimlane.

I hope this helps


Thanks. I am able to see the sub-tasks ID But unable to move the sub-tasks from board itself. Like its work in scrum board. 

You would need to ensure you display the sub tasks on the board in order to be able to move them. You may want to change the query then to pull in sub tasks where the parent issues are of type story and have the project team field set. You could do this using the subtasksOf Script JQL function as described on the documentation page linked above.

An example of the type of JQL you may want is shown below but you will need to update this to suit your actual requirements.

issueFunction in subtasksOf("issuetype = Story and 'project team' = adapter")

I hope this helps.


Like # people like this

Great!!. Thank you very much kristian.

It's working now as expected. 


Glad i was able to help.

If this solution is correct can you please mark it as accepted so that other users with similar questions can easily find it in future.



Thank you so much this was very useful sql .


Thank you Kristian!

This thread needs to be updated. This solution no longer works in 2019. 

Hello Alexander,

Actually, the query provided by @Kristian Walker _Adaptavist_ is still working on JIRA Server and JIRA Cloud Applications. You need the Scriptrunner plugin installed to use the subtasksOf issue function, as mentioned in the documentation below:

Script JQL Functions

That being said, can you please confirm if you have properly installed the Scriptrunner plugin?

If you have installed the plugin, can you please confirm if you are using JIRA Server or Cloud and what steps you are taking to reproduce the issue?

Let us know if this information helps.

The Scriptrunner costs extra and delivers essential functionality for filter stuff.

That's bad.

0 votes

This post is old but if someone searches for the info, you can use the following in JQL now:


issuetype in subTaskIssueTypes()


standard issues:

issuetype in standardIssueTypes()


or specifically:

issuetype = Bug

issuetype = Task

issuetype = Story

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Marketplace Apps & Integrations

How to create a Confluence page linked to a Jira cloud ticket

Have you been looking for a solution to easily create Confluence pages directly from a Jira Cloud issue? The no code solution is here with the brand new app Elements Publish to Confluence, which work...

26 views 0 1
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you