JQL Advanced Search on a list of 1000+ issues

[Godwin Labouh]

Hi dear Community,

Is it possible to search on a long list of over 1000 issues based on the issues id (e.g. key)

In other words either similar to a standard sql statement such as :

select column a, b,...,e where key in (key 1, key 2,...,key 1500,...key n)

or in a smarter way ?

Thanks in advance

Godwin

[Hannes Obweger - JXL for Jira · Accepted solution]

Hi @Godwin Labouh

you mentioned above that you're getting an error if you pass more than x key IDs. This problem occurs with all very long JQL statements; put simply, the web server that runs Jira Cloud has a limit of how much data can be sent to Jira in a single request, and when you send a very long JQL, you can exceed this limit.

I would still raise an issue with Atlassian, as this limit should really be removed or at least increased.

More generally speaking, querying your issues "key by key" isn't really ideal. Is there anything these issues have in common, so that you can use a different query? E.g., do they have a certain label, or anything else?

Best,

Hannes

[Godwin Labouh]

Hi @Hannes Obweger - JXL for Jira 

Agreed it's not optimal to query on a long list. It's an interim solution as no label or common parameter is available for now. Thank you for clarifying the server limit feature.

Best,

Godwin

[Aditya Verma · Accepted solution]

Hi @Godwin Labouh ,

Yes, it's possible. You just have to give the complete key.
Example:

key > ABC-4000

You can also give a range -> key > ABC-4000 AND key < ABC-5100

Thanks,

Aditya

[Godwin Labouh]

Hi @Aditya Verma 

Thanks for your reply. I'm however not sure what you mean. Is ABC-4000 an example of a key ID ?

The key IDs I have are random so no comparison (> or >) nor range is possible. I just have this list of 2000+ key IDs I want to search on.

Best,

Godwin

[Aditya Verma]

Yes, ABC-4000 is example of an key ID, where ABC is the project key.

You can search with 2000+ key IDs, for example:

key in (ABC-1,ABC-2,ABC-3......ABC-N)

You can select the columns from the columns drop down on the right.

Thanks,
Aditya

[Godwin Labouh]

OK I understand now, so thank you for clarifying.

I was doing exactly the same as you indicated but beyond 419 key IDs (strange limit for a list) my search does error with the message "Error occurred communicating with the server. Please reload the page and try again". Then following reload I get a new error with the browser "HTTP Status 400 - Bad Request".

So no way forward there hence my question if possibly there is another method to search on a long list of key IDs.

Still appreciate your feedback as it validates I was not doing something uncommon for jql.

Best,

[Aditya Verma]

Please raise a support ticket with Atlassian in that case.
I tested below query for 1100+ keys and it ran fine.
key in (ABC-1,ABC-2,ABC-3......ABC-N)

Thanks,
Aditya

[Godwin Labouh]

Sure. Thank you!