Finding issues that have an epic but the fixVersion on the epic is not set

[Joe Harmon]

I need to be able to find issues that have the fixVersion set to a version of "OS 3.4.0" and that also have an Epic but the Epic is not set to fixVersion "OS 3.4.0".  I tried the following but it didn't seem to work.

or fixVersion in ("OS 3.4.0") and type not in (Epic, Sub-task) and "Epic Link" is not EMPTY and issue in issuesParents("fixVersion not in ('OS 3.4.0')")

[Andy Heinzer · Accepted solution]

There is not a way natively to limit the results returned by a filter that a board is using.   You can limit other results, such as the issue navigator, but I don't think that will help you here.  This question has been asked before though, please check out

https://community.atlassian.com/t5/Jira-questions/How-to-limit-JQL-search-result/qaq-p/156795

In that thread, at least one other user found a way around this by using a plugin for Jira in order to gain a SQL like limit command that can be used.   There was a previous suggestion for this kind of behavior natively in Jira, see https://jira.atlassian.com/browse/JRASERVER-31384

However this was closed as something that is not planned to be implemented in Jira any time soon.  Sorry this probably isn't the answer you were looking for, but I hope this helps anyways.

[Mehmet Can Kırtaş _ALMBASE_]

Hi Rich,

You could use limitedResults() function of our add-on GO! JQL to search for issues with limited results.

You could try the plugin for free!

Best,

Mehmet