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

Rafael Santos January 2, 2023

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.

2 answers

1 vote
Alex Koxaras _Relational_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 2, 2023

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
1 vote
Carlos Garcia Navarro
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 2, 2023

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.

Suggest an answer

Log in or Sign up to answer