Can i know the JQL to pull of which project that has the highest number of tickets?

[Jeniffer Kamaraj]

Can i know the JQL to pull of which project that has the highest number of tickets?

[Victor Law · Accepted solution]

Hi @Jeniffer Kamaraj

Welcome to the community!

Agree with @Aaron Pavez _ServiceRocket_

JQL alone will not provide you with the number of issues per project.

However, you can utilize the Issue Statistics / Work item Statistics gadget from the Jira Dashboard with a JQL filter that includes the corresponding Jira projects. Then, you can have a quick report within Jira.

Thank you.

[Jeniffer Kamaraj]

Thanks!

[Aaron Pavez _ServiceRocket_ · Accepted solution]

Hi @Jeniffer Kamaraj 

There isn't a single JQL that will give you that number.

You can create a JQL  project in (project1,project2) with each project key and then export that to CSV or Excel.

Dont forget to add a column with the PROJECT field to be able to filter by project.

Regards - Aaron

[Jeniffer Kamaraj]

Thanks!