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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

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

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


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

That's bad.

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

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.

Thank you Kristian!

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events