How to convert JIRA URL into JIRA Query Language

[Hayley Wang]

Hi, I would like to seek advice on how to convert JIRA URL into JIRA Query Language? Given a JIRA URL, how do we find out the JIRA Query for the given JIRA URL?

[Walter Buggenhout · Accepted solution]

Hi @Hayley Wang and welcome to the Community,

The Jira URL and Jira Query Language (JQL) are totally different things, so I wonder what you are trying to achieve ...

While a URL is the address of a web page, JQL is the language Jira uses to search for issues in the system. In other words, they serve completely different purposes.

Incidentally, Jira has a search page that you can access through Filters > Advanced issue search. There you can search for issues using JQL. The URL (or web address) of that page is:

https://<your site>.atlassian.net/issues/?jql=order%20by%20created%20DESC

Maybe you are a bit confused by the fact that this url does contain a JQL parameter. This contains the filter that is currently selected on the page. If you update the JQL on your page and execute the filter, the URL will be updated automatically to reflect your search. 

So, in short: you cannot convert a URL into JQL. On the other hand, if you navigate to the advanced search page in Jira and execute a query there, the applied JQL will be updated automatically in the url of the page.

Hope this helps!

[Hayley Wang]

Hi, thanks for helping to try to answer the query, my query originate from the fact that i was provided with a JIRA URL to a project with a list of issues, but i would need to know what is the JIRA query that can bring me to the same list of issues in the JIRA URL. So my question is: looking at the list of issues in the provided URL link, how can i determine the same list's JIRA query? pls advise if you know the answer, thank you.

[Walter Buggenhout]

There's actually 2 options here: either the URL brings you to the issues page inside a project, where the default page you are directed to is the open issues list. The JQL for that is simply:

Project = <your project> And Resolution = Unresolved

Or the URL directs you to the advanced issues search as I explained in my previous answer. In that case, the JQL is displayed in the search bar on that page automatically, so no need to do anything at all.

[Hayley Wang]

Hi for my case, the URL does not direct me to the advanced issues search, there is no JQL displayed in the search bar as the search bar is not in the URL page..

I have a second question, when i try to export a list of issues, the limit is 2000 issues per export, how can I download a full list of 4000 issues part by part? I have tried this instruction Increase issue limit for Excel exports in Jira Cloud | Jira | Atlassian Documentation but does not work for me. When i right click on export cvs to obtain the URL, I was directed to an error message page telling me i cannot download more than 2000 issues. Pls advise, thanks!