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

Automation: How to get number of comment on an issue?

Bhavin Acharya

Hello,

I want to capture through Automation, how much comments an issue has?

Is it possible to get a number as output for Advance Compare Condition in Jira Automation.

Thanks for help in advance.

Bhavin Acharya.

Accepted answers

Mohamed Adel

Hi @Bhavin Acharya

You can use {{issue.comments.size}} and for detailed reference please visit Smart values - lists

All comments

Mohamed Adel

Hi @Bhavin Acharya

You can use {{issue.comments.size}} and for detailed reference please visit Smart values - lists

Ismael Jimoh

The above should is the answer here.

Thanks @Mohamed Adel .

Bhavin Acharya

Thanks @Mohamed Adel

Ana Laura de Melo

How did you create the automation? It worked?

Mattice Dossche

Hi,

Can anyone explain how to run the automation rule above?

If possible step by step please.

I want to count the total of all comments in a certain Service Management project.

Is this not possible through the 'Reports' via Jira?

Thanks for your help!

Kind regards,

Mattice Dossche

Chris McCullough

@Mattice Dossche I don't believe Jira allows you to do math expressions within the Filters so I am currently using a free app called "Sum Up Reports" to actually do the math for that sort of thing. You could also export all of the issues to an Excel file and then sum the total value from the field counting the number of comments on each issue.

For example what you want to do to start (assuming you haven't done anything yet):

Create a new Custom Field for numeric values
1. Mine is called "NC" for "Number of Comments"
In the project that you want to count all of the comments - create a new Automation rule
(Temporary) Add a scheduled trigger with a JQL filter for the project key
Add an action to Edit Issue Fields
Select the custom field you created before as the field to edit
Set the value of the field to: {{issue.comments.size}}
Publish the rule and run it
1. Note that you may need to run the rule multiple times and/or with different JQL to capture all issues if it's a large project since the automation rules will timeout after a certain amount of time. So in larger projects this may take a while.
Once all existing issues have been edited to count their total number of comments change the trigger on the rule to use the "Issue Commented" trigger and have it run for "All Comments". Then save and publish the rule so it runs every time there's a new comment on any issue in that project.
1. At this point you shouldn't ever need to manually run the rule and it will just work quietly in the background
Go to the Advanced Seach page and filter for the project using the new rule/custom field. You may need to do a JQL search for the project key to get all issues in the project.
In the top-right corner, click on Export and then "Export Excel CSV (All Fields)"
1. Depending on the project size this could be a huge file. My particular project has about 2,000 issues and the .csv file here was about 12 MB
Open the exported file in Excel and find the column with your custom field.
Select the column to highlight everything and look at the "Sum" value in the lower-right corner of Excel

Anil Singh_x1ujgy

Hi,

Thanks for this I've managed to setup the rule for new tickets but I'm stuck on this step for old tickets. Can you add a screenshot of your example please.

(Temporary) Add a scheduled trigger with a JQL filter for the project key

Thanks

Anil.

Welcome!

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

Quick Links

Unanswered
Groups
Help

Find more posts tagged with

cloud

jira-software

jira-software-cloud