List Story and it's sub-tasks in order for Jira Cloud using jql

Question

Team,

Can some one help in getting the list of Story and Sub-task in order. we do have ScriptRunner plugin. We have Sub-task assigned to a person B, want to retrieve Story Point of the it's parent. i.e Story using this list. I used issuefunction SubtaskOf or ParentOf which works but not getting all of them at a time.

List should be like below:

Story A

Sub-task C

Story B

Sub-Task D

Note: Sub-task C is associated to Story A & Sub-task D associated to Story B

Instance: Jira Cloud

Kristian Walker _Adaptavist_ · Accepted Answer

Hi Suresh,

Thank you for your question.

I can confirm that we have responded to your question that you have created for this inside of our support portal.

However, I have included the answer below which is that I can confirm that ScriptRunner for Jira Cloud does not provide any JQL functions to list or order stories and their linked sub-tasks in order in the search results.

The reason we cannot provide this functionality is due to the fact that Atlassian does not provide the API's that would be required to create this functionality.

Regards,
Kristian