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
Community Members
Community Events
Community Groups

Render Number of Issues in Sprint

Hello All,

Is there a way to automate sending a Slack message that renders the total number of issues in sprint and per project with a JQL query and/or smart values? For example, here is what I would like to send in the Slack message


Sprint 13 (12 issues)

  • Project Name 1 (3 issues)
  • Project Name 2 (5 issues)
  • Project Name 3 (2 issues)
  • Project Name 4 (2 issues)


I already know how to send an automated Slack message from Jira via a webook. I'm unsure how to query the db for the total number of issues in a sprint and break it down by project to render the total number of issues assigned to that project within the sprint.

Thanks in advance for any help someone can provide.

1 answer

0 votes

Is the Sprint a static value or are you trying to derive that dynamically?

Is the list of projects from which issue will be included static, or is that also something you are trying to derive dynamically?

Note in Cloud you can't query the database directly. You can use JQL to execute queries.

If the Sprint is a static value you could use the Lookup Issues action to get all issues in the sprint:

sprint = <id of the sprint>

Lookup Issues returns a list of issues. You can get the number of items in the list using the size smart value:


You might assign that to a variable (another Automation rule action that is available) and then execute additional Lookup Issues Actions for looking up the issues that are in that sprint and part of a given project, assigning the size result for each lookup to another variable.

I know it's deficult for me but help you to teach about this project

Thank you

Suggest an answer

Log in or Sign up to answer
Site Admin

Atlassian Community Events