How to get list of sub subtasks in jira related to a task under a particular Epic using JQL

[Karthikeyan Ramachandran]

Intention to create a dashboard that will have a widget for each epic's Subtasks.

[Karthikeyan Ramachandran]

Tried using an JQL and achieved this

issueFunction in linkedIssuesOfAll(" 'Epic Link' in ('<Epic>') AND Type in (Task)") AND Type in (Sub-task)

[Trudy Claspill]

Hello @Karthikeyan Ramachandran 

Welcome to the community.

Jira does not natively provide capabilities to create a filter to get those results. Do you have any third party apps installed that extend JQL search functionality? Is you company open to paying for such third party apps?

[Karthikeyan Ramachandran]

Nope . Intention to see if JQL can get that

[Trudy Claspill]

As I said, Jira's native JQL capabilities will not be able to do this in a single JQL query.

If you have access to "issuefunction" then you do already have a third party app installed that extends the JQL capabilities. "issuefunction" is not natively available in Jira. And "linkedissuesofall" is specifically provided by the Adaptavist Scriptrunner app.

Did the query you tried get you what you wanted?