nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Pie chart JQl query issue

sap1

Hi,

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?

Regards,

SAP

Accepted answers

sap1

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.

All comments

sap1

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

Udo Brand

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).

Udo Brand

I just tried and could not enter more then 2000 characters

sap1

Is there any length limit to a particular query?

sap1

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?

Peter Van de Voorde

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?

Udo Brand

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.

sap1

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.

sap1

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira-administration