nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

David Wood_97jxj1

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.

Jira count of issues.png

Accepted answers

Bill Sheboy

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

All comments

Bill Sheboy

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_97jxj1

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_97jxj1

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

issue-link

automation

count