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; } } }

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

Accepted answers

Aditya Verma

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

Hannes Obweger - JXL for Jira

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

All comments

Aditya Verma

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,

Hannes Obweger - JXL for Jira

Hi @Godwin Labouh

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

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

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud