Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,459,315
Community Members
 
Community Events
176
Community Groups

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

Edited

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

1 answer

1 accepted

2 votes
Answer accepted

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

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

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

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

Like Bill Sheboy likes this

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events