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

Question

Aaron Pavez _ServiceRocket_ · Accepted Answer

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

Victor Law - Ricksoft · Accepted Answer

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.