How to see the total number of tickets in filter JQL when it is over 1000+ (cloud)

[Suzie Bedo]

we are doing migration from server to cloud. i wanted to compare the number of tickets but the cloud is not showing the total number of tickets like the server does:

It just says 1000+ in cloud.

I tried to use the filter counts but it does not allow me to select the project type and it does not count beyond 9999+.

Why the cloud cannot do what the server could?  

But regardless, how to check this, please? or is there anything else that can be used to run reports before and after migration?

We will also need to check whether the partner responsible for migration will update the number of changes that between the migration and the switch over occurred.  

thanks!

[Asha Goyal]

Hello Team, 

If you just want to confirm and check exact number of 1000+ issues, there is a workaround. After running the JQL query, just tap on the 'Export' icon on top right side and select
'Print List' option. It will show the full list of the issues with total number of issues.

Hope this helps.

Thanks

[Mikael Sandberg]

Hi @Suzie Bedo,

Welcome to Atlassian Community!

You can do it by creating an automation that is using the scheduled trigger, and when you validate the JQL it will show you the total number, similar to this:

 

[Suzie Bedo]

Thanks @Mikael Sandberg where do I put this JQL in as search is obviously not the right place ;) 

[Mikael Sandberg]

You have to create a new scheduled automation (but you do not have to save it), the JQL is part of the schedule. Just click the checkbox for "Run a JQL search..." and you will see the where you can enter your JQL. Then just click validate query and you will get the total number of issues found.

[Louise Baker]

This is the solution?!?!?!?! To go into automation, run your filter there, just to see the actual number?!

[Soporte Inlogiq]

Yep, sounds crazy. I believe you can open your issue list in excel and see the results.