What JQL query can i do, that I can save, that will return all issues for all of JIRA?

[Eric Sara]

I am using saved filters in a number of areas of JIRA.  For example on dashboards. On some of them I do not want to filter out any issues but the gadget asks for a saved search so I need one that includes every issues in JIRA.

I have got around this by doing a query of "key != ZUI-1" (this being a random issues that I know I do not need in the list of all issues). 

However, I am wondering if there is a much simpler way to do this.

[Inactive Stephen · Accepted solution]

Hi @Eric Sara

You can do this by putting in an ORDER BY function into the JQL search box - eg. "order by created DESC"

This is how 'All Issues' creates this view - to see that in action, open up the issue search page and in the right-hand menu select 'All Issues'. To see the ORDER BY function you'll need to be on Advanced Search.

Ste

[Eric Sara]

@Inactive Stephenyou are a legend. Thanks,

[Dave Theodore [Coyote Creek Consulting]]

There should be no reason to do what you are proposing.  How useful is a list of 100,000 issues? It places a large load on Jira when you do this type of query, so I would highly recommend against it.

Best practice is to use multiple targeted queries to get what you want. 

[Eric Sara]

Hi Dave, appreciate your comments and the load that it puts on on Jira, but, we do have need for it. Should we find that Jira is suffering based on it then we will need to look at a different way of doing this.

Anyway @Inactive Stephen was able to give a solution that is working and with the 30,000 issues we have at the moment all is working ok.