How can I submit a JQL that returns the list of existing projects?

Question

Hello Community.

How can I make a query, where it brings me the list of Active Projects? As on screen:

https://yourcompany.atlassian.net/jira/projects?page=1&selectedCategory=all&selectedProjectType=business&sortKey=name&sortOrder=ASC

On this screen, for example, there is a field where I can put a string that filters by the project name. How can I apply other filters, for example the name of the leader?

Thanks.

Alex Koxaras -Relational- · Answer

Hi @Rafael Santos

JQL is used to return issues and nothing more. However you can:

* Use JQL to list all issues you have access to, export them to excel and then process it with a pivot table in order to get the project list you want
* You can use rest API to get a JSON with all projects
* Use a 3rd party app which could do that trick for you

Carlos Garcia Navarro · Answer

Hi @Rafael Santos ,

Like mentioned in this other post, JQL is to query issues not projects, but you can use some of the suggestions here, like using the projects gadget:

https://community.atlassian.com/t5/Jira-questions/JQL-to-list-all-projects/qaq-p/2019450#:~:text=To%20get%20the%20list%20of%20all%20the%20projects%20in%20Jira,you%20have%20permission%20to%20see.