Need to implement Warranty days field which should automatically increase everyday

Question

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

Bill Sheboy · Answer

I am not currently using Assets with JSM and so cannot check that, although I expect it is possible.  The challenge for your scenario is the volume of work items rather than where the values are stored.

Sidharth verma_cfm03m · Answer

Hi @Bill Sheboy

Thanks for your suggestions!!

I will look through the first solution and see if I can implement it if possible. However, just wanted to know is it possible to do it via an asset field in a better way?

Like if I assign an asset field to the issue and assign it value based on the date and delivery date.

Regards,

Sidharth

Bill Sheboy · Answer

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