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

2 answers

1 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. 

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.


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!

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Feb 07, 2019 in Marketplace Apps

A Timeless Love Story

It started as any story starts, on a normal, rainy day.   Admin meets App, and her name was Klok2, and like any first relationship we were both trying to make it work but neither one knew what...

445 views 8 26
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you