I am trying to create a query which brings in data from a task and also from the associated Epic. Pulling the Tasks data is fine, but how do I reference the linked Epic data?

[Ashwin Kupatkar]

Hello,

My query is something like this

project = "project-name" AND issuetype = Task AND summary ~ "Create High Level Estimate" 

What changes should i make?

Also i want to create a query to show all EPICs that have a Task with Task.Summary ~ “Create High Level Estimate” and Task.Status <> Completed

How do i achieve this ?

Thanks,

Ashwin

[Tarun Sapra]

It's achievable using Script Runner plugin 

linkedIssuesOf function

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html

JIRA Agile users can query on epic links, eg find all Epics that have unresolved stories:

issueFunction in linkedIssuesOf("resolution = unresolved", "has Epic")

[Tarun Sapra]

https://marketplace.atlassian.com/plugins/com.onresolve.jira.groovy.groovyrunner/server/overview

[Ashwin Kupatkar]

Thanks Tarun. But iam using JIRA on cloud.

[Sunil Muniyal]

Is there a way to achieve this on Cloud edition?