How to use top command to extract limited number of records in JIRA

[Yashodhan Joshi]

In JIRA service management, want to use TOP command to fetch top 1000 records.

How to fit the same in query? What is the valid syntax?

[Marc - Devoteam]

Hi @Yashodhan Joshi 

As @Jack Brickey mentions JQL shows the number of items fond by the clause. In cloud this will be a 1000 max and on Data Center this can be more based on the setting in the configuration.

But you use the ORDER BY clause to get the issue relevant to you. You are able to export a 1000 issues at a time on Cloud, Data Center is dependent on the configuration

[Jack Brickey]

Hi @Yashodhan Joshi , welcome to the community.

I am unsure what you mean by top command. However, by default, JQL will always return 1000 issues if there are more than 1000. Which 1000 issues, depends on the use of ORDER BY. For example, assuming there are >1000 issues in project abc

project = abc ORDER BY Priority DESC

will return 1000 issues with priority highest to lowest