Hi Team,
We are using Jira cloud, we have a field called as Acceptance criteria associated to story and bugs, We need a report, how many times this field values have been updated. Please help us with a free add-on or any other options available for this activity.
Regards,
Mohan S
Hi @mohanbabu.s ,
You can also use the changelog of an issue to look the number of changes of a certain field.
With an automation rule you can 'easily' get it.
Automation rule:
Trigger: choose one of your liking (start with manual, so you can test the rule)
Action: Send web request
Action: Create variable
{{#=}}
{{#webResponse.body.values}}
{{#items}}
{{#if(equals(field,"Acceptance criteria"))}}1{{/}}{{#if(not(equals(field,"Acceptance criteria")))}}0{{/}}
{{^last}}+{{/}}
{{/}}
{{^last}}+{{/}}
{{/}}
{{/}}
The above rule will create a comment in your issue.
You can also create a new field and use {{numberOfUpdates}} as the value.
Good luck,
Rudy
I believe that endpoint can only return a maximum of 100 changes:
And so if the issue has been changed more than 100 times and the updates of the field were before those 100 changes, pagination would be required to get an accurate count...which could be challenging to accomplish with a rule.
Kind regards,
Bill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Bill Sheboy That could become an issue, true. Maybe add ?maxResults=1000 to the endpoint?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The limit for that one is maxResults=100, after which the call returns the nextPage link to follow for more results.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All/ @Rudy Holtkamp ,
Our requirement is not getting completed with above scenario, we need to verfiy for a complete sprint.
Please help us with a different scenario or updating the existing script.
We have updated the script in below format:
Smart value : {{#=}} {{#webResponse.body.values}} {{#items}} {{#if(equals(field,"Acceptance criteria"))}}1{{/}}{{#if(not(equals(field,"Acceptance criteria")))}}0{{/}} {{^last}}+{{/}} {{/}} {{^last}}+{{/}} {{/}} {{/}}
Web request: {{https://idpchange.atlassian.net/jira}}/rest/api/3/issue/{{DTP11-49}}/changelog
Please let us know if there is an update.
Regards,
Mohan S
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @mohanbabu.s ,
You can use the automation rule to update a field in an issue. If you want to have all the Acceptance criteria summed up for all the issues in the sprint, then you should create a filter for that sprint, and show the column with the fore-mentioned field.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @mohanbabu.s ,
You could use 'counter'/number field to achieve this + automation rule that updates the number field value each time 'Acceptance criteria' value is changed.
So, what you can do is to set this counter number field to some value (e.g. '0') and then use smart values and math expressions to change the counter value. In the example below, a custom field with ID 10061 is actually this 'counter' number field named "Counter 'Acceptance criteria'".
Hope this helps.
Cheers,
Tom
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All thankyou for your swift support, I will check this scenario and update you if there is an issue.
Regards,
Mohan S
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.