JIRA Limit of chars in JQL Query / max query length

Hi,

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

Is there a way to increase this?

Thanks!

Dirk

4 answers

1 accepted

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.

I was wrong this is fixed in JIRA 6.0.5 see

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

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

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

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

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

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Wednesday in Jira

Join our webinar: How 1B+ feature flag events helped us build the new Jira

Every time you release software, there's a bit of risk – that there's a bug, that something breaks, or that the feature doesn't resonate with customers. Feature flagging helps make high stakes s...

91 views 0 1
Join discussion

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