How can I get a count of tickets, then email it to myself?

[David Wood]

I'm currently trying to automate a small task for our reporting where we need to know the number of tickets which are not in the status of "closed" at month end each month.  Using the automation I feel like I'm close but doing something wrong as no value is output.

Also, just to let you know, that the JQL returns the value I want when test it but the output via email does not, where {{LookupIssues.size}} variable value is expected the email is blank.

[Bill Sheboy · Accepted solution]

Hi @David Wood 

Smart values are case-sensitive, so perhaps try

{{lookupIssues.size|0}}

Please note that I added null handling so this will always return a number.

Best regards,
Bill

[David Wood]

Hi @Bill Sheboy 

Thanks a lot for your reply, it has helped as the rule now outputs a number; although, I think the limitations of max 100 rows returned from a JQL query is now giving me trouble.

We have a fairly large number of tickets we are working with and wanted to ask if you knew of any alternative way that it would be possible to handle retrieving this count.

Best Regards,

Dave

[Bill Sheboy]

Hi, Dave.

Short answer is: no.  JQL is throttled to return up to 100 issues, and even the REST API requires calling in chunks to get more issues.

Possible work-arounds are:

• Refine the JQL so it would return less than 100, and use multiple calls.  E.g. reporting by project, by create month, by status category, etc.
• Or, if you want to investigate other options, consider looking at the built-in dashboard gadgets.  They do not all appear to have the same limitation.
• And on the expensive side, there are probably reporting tools in the marketplace for purchase which are not limited by this 100 issue constraint

Sorry I could not be of more help on this one.

__Bill

[David Wood]

Hi @Bill Sheboy 

Thank you again for all the information, its been really helpful and although Jira has some limitations you've explained everything and given the best answers I could ask for - much appreciated!

Thanks,

Dave