I'm trying to render results in a macro in Confluence. The following query will get all issues in epics where the Epic isn't in my project.
fixversion = 123 AND issueFunction in issuesInEpics("project != ABC")
However that query will search all Epics in Jira. It takes longer than usual to complete and as a result the macro in confluence times out. I don't have access to increase the time out setting. So I was wondering of there a more efficient way to get the results quickly.
This query does not appear to do that as it takes just as long...
project = ABC AND fixversion = 123 AND issueFunction in issuesInEpics("project != ABC")
Is it possible to write a more efficient query to achieve that result? Example "Get me all issues in my project ABC with fixversion = 123. Then query that result to get a sub set of issues where Epic in Epic Link isn't in my project"