JIRA Limit of chars in JQL Query / max query length

[Dirk Bromberg]

Hi,

we found a limit of 2000 chars at the jql textbox.

Is there a way to increase this?

Thanks!

Dirk

[Udo Brand · Accepted solution]

I doubt you can in crease it.

But you can use as an example queries like

filter ="12345" and filter = "12367"

where 12345 is the ID of filter query with 1900 characters and 12367 is the ID of a Filter query with 1500 characters.

So you simply need to split your overlong filter query into two or more parts and combine them again using above syntax.

[Udo Brand]

I was wrong this is fixed in JIRA 6.0.5 see

https://jira.atlassian.com/browse/JRA-31774

[Sive Kavanaugh]

Thanks - I couldn't get that to work initially, so learned some nifty JQL that kind of allows a query based on a sub-query, so I got myself going again, and slightly better b/c I don't have to upkeep the list of Epics...

[Sive Kavanaugh]

We are on JIRA 6.4 (server, not hosted) and I'm trying to paste in a JQL with 2054 characters, and it will only paste 2000 characters.  I'm on Chrome, have not tried on Firefox and do not have IE.  Help?  Below is the example:

"Epic Link" = PROTON-22175 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-22175") OR
"Epic Link" = PROTON-22583 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-22583") OR
"Epic Link" = PROTON-22617 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-22617") OR
"Epic Link" = PROTON-22181 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-22181") OR
"Epic Link" = PROTON-22553 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-22553") OR
"Epic Link" = PROTON-22354 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-22354") OR
"Epic Link" = PROTON-21134 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-21134") OR
"Epic Link" = PROTON-21999 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-21999") OR
"Epic Link" = PROTON-20485 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-20485") OR
"Epic Link" = PROTON-22165 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-22165") OR
"Epic Link" = PROTON-22660 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-22660") OR
"Epic Link" = PROTON-22883 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-22883") OR
"Epic Link" = PROTON-22886 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-22886") OR
"Epic Link" = PROTON-22884 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-22884") OR
"Epic Link" = PROTON-22889 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-22889") OR
"Epic Link" = PROTON-21109 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-21109") OR
"Epic Link" = PROTON-21868 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-21868") OR
"Epic Link" = PROTON-22055 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-22055") OR
"Epic Link" = PROTON-19834 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-19834") OR
"Epic Link" = PROTON-23212 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-23212") OR
"Epic Link" = PROTON-23288 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-23288") OR
"Epic Link" = PROTON-22419 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-22419") OR
(type != Epic AND labels in (AuroraGA))

[Udo Brand]

Split your query into two like Filter1: "Epic Link" = PROTON-22175 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-22175") OR "Epic Link" = PROTON-22583 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-22583") OR "Epic Link" = PROTON-22617 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-22617") OR "Epic Link" = PROTON-22181 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-22181") OR "Epic Link" = PROTON-22553 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-22553") OR "Epic Link" = PROTON-22354 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-22354") OR "Epic Link" = PROTON-21134 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-21134") OR "Epic Link" = PROTON-21999 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-21999") OR "Epic Link" = PROTON-20485 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-20485") OR "Epic Link" = PROTON-22165 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-22165") OR "Epic Link" = PROTON-22660 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-22660") and Filter2: "Epic Link" = PROTON-22883 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-22883") OR "Epic Link" = PROTON-22886 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-22886") OR "Epic Link" = PROTON-22884 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-22884") OR "Epic Link" = PROTON-22889 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-22889") OR "Epic Link" = PROTON-21109 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-21109") OR "Epic Link" = PROTON-21868 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-21868") OR "Epic Link" = PROTON-22055 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-22055") OR "Epic Link" = PROTON-19834 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-19834") OR "Epic Link" = PROTON-23212 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-23212") OR "Epic Link" = PROTON-23288 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-23288") OR "Epic Link" = PROTON-22419 OR issueFunction in subtasksOf("\"Epic Link\"=PROTON-22419") OR (type != Epic AND labels in (AuroraGA)) and use jql: Filter = Filter1 or Filter = Filter2

[RambanamP]

this problem seems to be on chrome and firefox and it is fixed on jira 6.0.5

check this

https://jira.atlassian.com/browse/JRA-33795

https://jira.atlassian.com/browse/JRA-31774