JQL to show Epics related to current Sprint without add-ins or additional software

[Heather Hale]

Not sure if this is possible with the native JIRA JQL, but I'm looking for a way to see all the UNIQUE Epics, and fields within them, that are tied to the Stories in a current Sprint, without any additional plug-ins/add-ons.  My work doesn't allow us to install anything at all, so it would have to be native to JIRA. For the current Sprint, I need to display the "Due Date" and other fields within the Epics that are tied to it.

[Trudy Claspill · Accepted solution]

Are you working with Jira Cloud or Jira Server/Data Center?

[Heather Hale]

If I click on the help button, it says I'm on the server/data center.

[Trudy Claspill]

Are there any search-extending apps already installed on your instance? If you don't know, check with your Jira Administrators.

[Heather Hale]

We have no additional apps.

[Trudy Claspill]

Without third party apps there is no way natively to build a single query that will provide you with the results you are seeking. And Jira does not natively support nested queries.

I think the only way you might be able to do this is with a series a REST api calls that execute a query and then use the results to build and execute another query, and so on. But, I haven't worked with Jira Server/Data Center since v7.13. It is possible that there may be native features available now of which I am unaware.

[Heather Hale]

I wound up having to to use "issueFunction in issuesInEpics" & display the info on a Dashboard.

[eden.owen]

@Heather Hale I'm laughing because i've been trying to figure out how to do this for years. I see that your comment here spans almost two years. I can relate to this. What do you mean by issuefunction? 

[Trudy Claspill]

Use of "issueFunction" is an indicator that a third party app has been installed that extends the JQL functionality.

[Heather Hale]

Since my Corporation controls all permissions, I'm not allowed to view any info on this. I had to go by what the JIRA group told me & they told me we had none lol.  It was "Everything we have is what comes with JIRA when it's installed". I didn't have a lot of faith in that group to start with, but now? LOL
Thanks for the info. =)