Is it possible to set a hard limit on results of JQL?

[Rich Scire]

We recently had an outage, apparently due to a mis-constructed JQL statement in an Agile board filter. The filter resulted in almost 500K issues being returned. Is it possible to limit for the entire instance the number of rows returned for a JQL query?

[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