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; } } }

Counting Amount of Issues in Specified Status

Raymond Jenks

Hello,
I am trying to automate a part of my Next-Gen project and have been struggling to get this one output to print properly. My automation successfully runs a check every morning to see if there are any new tasks created in a specified status called Under Investigation and returns a message to our Microsoft Teams channel.
The issue is that in the statement sent to our Teams channel I want it to return the number of issues in that specific status. I have attempted several iterations of {{issue.status.name.size}} or .count or .value to no avail. If you could please point me in the right direction as to what syntax I need to perform this print out and why that would be great.

Thanks.

Accepted answers

Bill Sheboy

Hi @Raymond Jenks -- Welcome to the Atlassian Community!

Are you using an automation rule to do this? If so, you could try something like this:

Trigger: scheduled once per day (perhaps at a specifc time using a CRON expression)
Action: Lookup Issues with JQL to find issues in your status
Action: send a message to your MS Teams channel with the count: {{lookupIssues.size|0}}

That last part handles a default of zero when there are no issues in the status.

Best regards,

Bill

All comments

John Funk

Hi @Raymond Jenks - Welcome to the Atlassian Community!

It might be because it is a Next-gen project and not all Automation functionality works with them.

Can you try the same notice on a Classic Software project to see if it works?

Raymond Jenks

I just attempted the same syntaxes mentioned above on a Classic Project and still none of them worked. I'm certain the syntax I've chosen to get this output is incorrect. I just need to be pointed in the right direction on that.

John Funk

Can you share a screen shot of the rule with the details for the syntax?

Bill Sheboy

Hi @Raymond Jenks -- Welcome to the Atlassian Community!

Are you using an automation rule to do this? If so, you could try something like this:

Trigger: scheduled once per day (perhaps at a specifc time using a CRON expression)
Action: Lookup Issues with JQL to find issues in your status
Action: send a message to your MS Teams channel with the count: {{lookupIssues.size|0}}

That last part handles a default of zero when there are no issues in the status.

Best regards,

Bill

Raymond Jenks

That worked, thanks Bill! I'm not sure why {{lookupIssues.size}} doesn't work with the JQL search built into the Schedule component but I'll take it.

Bill Sheboy

I am glad to hear that worked for you.

When you use the Scheduled trigger with JQL that helps when you need to process each item one-by-one, such as for editing. Lookup Issues is when you need the set for non-edit stuff, like counting or reporting.

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud