Pie chart JQl query issue


We have a Jql query which searches for certain issues.The query is like

Key in(xxx,xxx,xxx..........172ndxxx).Like this there are 172 keys present.The issue now is that the query throws error when we click the pie chart.Its kind of strange because the query would normally give correct output.But if we click pie chart it throws peculiar error like bracket missing whereas the query used doesnt have this problem.

I am doubtful if its the number of keys i have given for the "IN" clause the problem.Beacause when i give just 127 keys it works.Fails just when i extend it to 172.

Can anyone let me know if i am right in thinking that way?



6 answers

1 accepted

0 votes
Accepted answer

Hi This issue has been accepted by atlassian as a problem in the Jira version 5.2.10.This was said to be resolved in Jira 5.2.10.However this issue still persists in Jira 6.0.2 and i have raised a problem ticket regarding the same.

is there like a reason why the error comes only while clicking from the pie chart?

I guess your query becomes too long. Your original query is less than 2000 characters (and works), once you click on a pie off the pie chart an additional statement is added to the original query and it becomes longer than 2000 character.

Please confirm with your 127 Key query and see what statement is added, then try to add this statement to your 172 key query (and check the length).

I just tried and could not enter more then 2000 characters

Is there any length limit to a particular query?

Well when i click the pie chart what happemns is that the query stops in between even without a closing bracket and hence the error comes.But i dont get how that happens.I checked now and it gets cut off at 1659 charecters.Add to that And project="xxxxxxx".It doesnt cross 2000.So i guess that couldnt be the reason.Am i right?

Well I tried to reproduce your error, but no success. Used a query with 1991 characters, and then clicked the pie. No error occured and the query is now 2010 characters long.

Strange since I cannot paste a query into query field with more than 2000 characters (it truncates). So i was wrong with my assumption.

Could you not use a label or custom field to group those 172 issue together and get a much neater and shorter query?

btw: which error is thrown?

Well its a request made to me and it came up because this query is used as the filter for the pie chart.When u click a pie it gives the error that"page cannot be displayed".Click the diagonise connection and then close it redirects to the required search page where the error pops up that "Bracket is missing".even if we edit and save it next time we face the same issue.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,301 views 12 19
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you