Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Can we limit Empty JQL search result in JIRA?

Kiranped August 29, 2018

Can we limit Empty JQL search result in JIRA? If Yes,

when the User clicks on 'Search For Issues' > Issues Menu an empty JQL is requested. My instance has 1 Million issues due to which it takes time to load empty JQL query.

just by appending JQL query to empty JQL request, for example:

Empty JQL request: https://jira-dev.xxx.com/issues/?jql=

https://jira-dev.xxx.com/issues/?jql=createdDate%20%3D%20currentLogin()%20

 

Can we improve the performance by not loading all issues for empty JQL? 

2 answers

1 accepted

0 votes
Answer accepted
Josh Steckler
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 29, 2018

Not sure which version you're on, but in 7.9 a feature was added to make it so empty JQL queries can return no results. 

Look for "Disable empty JQL queries"

https://confluence.atlassian.com/adminjiraserver/configuring-jira-application-options-938847824.html

 

Also release notes:

https://confluence.atlassian.com/jirasoftware/jira-software-7-9-x-release-notes-946034808.html

Kiranped September 17, 2018

Thanks for updating Josh, We are using 7.6 version.

0 votes
Mohamed Adel
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 29, 2018

@Kiranped 

If you didn't update JIRA configuration, by default it will display on 1000 issues as max limit.

You can check the Advanced setting from System ---> General Configuration ---> Advanced setting and check the value for this property "jira.search.stable.max.results".

Kiranped August 29, 2018

Hi Muhammet Adel,

Thanks for the reply, I am using the default settings of JIRA.

jira.search.stable.max.results is set to 1000.

 

Empty JQL request (https://jira-dev.xxx.com/issues/?jql=): gives below result

Snip20180829_9.pngwhen I tried appending JQL string to empty JQL request (https://jira-dev.xxx.com/issues/?jql=assignee%20%3D%20kiranp%20 ): gives only a few issues in result But it takes almost same time as empty JQL.

 

How do I improve performance here?

Suggest an answer

Log in or Sign up to answer