Need to implement Warranty days field which should automatically increase everyday

[Sidharth verma]

Hi,

We have setup a project where all issues/work once delivered to the customer will have a warranty days clock started and everyday this field needs to be updated with the increase in number of days. we have tried using automation to update the field every day. However, with each passing day we will have 100 new work items added and they need to be updated and since an automation can only do 1000 at a time most of the time it throttles and unable to update them and also because of this some other automations do not run. 

Can you suggest some alternative method to achieve this where we have a calculated field which can update its value based on the formulae = ( Now() - delivery date).

do let me know what a solution to this problem can be.

Thanks, 

Sid

[Sidharth verma]

Hi @Bill Sheboy ,

actually, my requirement is to update the number of days past the delivery date in the custom field so that it can show in the report to the customer on how many days are there in their warranty. 

so, it should show number of days past the delivery date and hence we are updating it every day.

Regards,

Sidharth

[Bill Sheboy]

Hi @Sidharth verma 

How are you using the "warranty days" field?

Another possibility is when you know the duration of the warranty period, add that amount to the value of {{now}} and store that in a custom field.  Then a Scheduled trigger rule can use JQL to find work items for which the warrant period has expired to decide next steps.

Kind regards,
Bill

[Bill Sheboy]

Thank you for the additional information, and...Please stay within one thread when responding.  That will help people reading this question in the future know if there are multiple solution approaches.

As you want to update each work item daily, and you are constrained by the service limits of automation rules, you have a few options:

• Use two custom fields and a scheduled trigger rule
  • One custom field is your "warranty days" and another is the date / time of the last update to that field
  • Using a scheduled trigger rule which runs hourly, use JQL to find any work items where the last updated date / time for the field is empty or more than 24h ago, and then update both fields.  Running this rule hourly will find the work items to update, halting when it hits the limits.  The next execution will process another batch.
  • Before using a rule like this, discuss the scenario with your Jira Site Admin to ensure you do not encounter other service limits.
• Investigate marketplace apps for calculated fields
• Build your own application which calls the REST API endpoints for bulk-edit of work items
• A risk approach is to combine the 1st and 3rd approaches, using an automation rule which calls the bulk-edit endpoint from a rule