Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,466,078
Community Members
 
Community Events
176
Community Groups

Sliding Due Date calculation.

Edited

I'm not sure if I have used the correct wording.
I'm looking for a process of being able to achieve a sliding Due Date, calculation and don't want to have to manually updated the value

OOTB there is a Due Date field that isn't populated, I've already asked the question from Atlassian of how this is achieved and I was advised by an Automation process, I've followed the recommendations for the Due date off triggered on comments and waited over  the weekend to see if the Due date field was populated and or changed , it hasn't been populated at all. so I don't think it has worked 

I want to Due date to be set off the SLA's when the ticket is raised by the customer  and accepted by our company, the time is dependent on the Priority of the ticket when raised. which is also considers the the daily working hours  Monday to Friday 8am to 5pm.

To make it easier to explain the SLA is 24/7 

If a ticket was raised on the 01 March 2023 as a Pri 3, the SLA for a Pri 3 is 20 days so I would expect the Due date to be populated as 20 March 2023.

If that ticket was Open with me for action the due date should remain 20 March 2023.

If on the 01 March I investigate the ticket and set the ticket to Awaiting Customer Action and ask the customer for logs etc, I'd expect that every day that ticket is Awaiting Customer action the Due date is re calculated every day, which would mean that if the ticket was held with the customer until the 5 March the new Due Date would be Calculated at  (5 +20) 25 March 2023. If they sent the requested information.
Like wise if we have a status Vendor Action then the Due would also be re calculated depending on how many days where left..

Is that at all possibly - I want to be able to stop 
a. the Due date from being Blank
b. the Due date set on the ticket being raised  and not moving
c. a ticket being with he customer for action and then the customer saying you have breached your SLA the Due date has passed. 
 

1 answer

1 accepted

2 votes
Answer accepted

Hi @Dave 

First of all I want you do understand that what you are requesting are two distinct actions:

  1. Calculate a date based on certain criteria
  2. Construct an SLA based on the above date

For the 1st request you have to make this calculation in one of two ways:

  • Jira Automation Rule
  • Workflow post function

Either way will work as long as you create the rule or the post function properly. You might need an app like JMWE, JSU, JWT or Scriptrunner to calculate the date from within a workflow. For Jira Automation, smart values will be the way to go.

 

  • Q: If a ticket was raised on the 01 March 2023 as a Pri 3, the SLA for a Pri 3 is 20 days so I would expect the Due date to be populated as 20 March 2023.
  • A: This can't be done out of the box, but can be done using an app from the marketplace. E.g. I've used an app called Time to SLA which uses dates as starting points and you can set your SLA accordignly. Of course there are also other apps in the marketplace which you can explore and see if they suit your needs (cost, functionalities,  etc). Keep in mind that you have a 30 day evaluation period.

 

  • Q: If on the 01 March I investigate the ticket and set the ticket to Awaiting Customer Action and ask the customer for logs etc, I'd expect that every day that ticket is Awaiting Customer action the Due date is re calculated every day, which would mean that if the ticket was held with the customer until the 5 March the new Due Date would be Calculated at  (5 +20) 25 March 2023. If they sent the requested information.
  • A: Most likely you can achieve this as well with a 3rd part app and with Jira automation (because you have to recalculate the date)

 

  • Q: Like wise if we have a status Vendor Action then the Due would also be re calculated depending on how many days where left.
  • A: If by vendor you mean a 3rd party, then this question falls in the above question. I mean it's similar.

Let me know if that helps.

Hello @Dave  and thank you again @Alex Koxaras _Relational_ for mentioning us!

You can update the Due date field every time that it is transitioned from a certain status to another by using the JWT post function Update fields in combination with the parser function dateTimeToString().

We explain in our use case Set a date field to a future date how you could implement this. However, your requirement involves the usage of priorities to determine the number of days that should be added to the Due date.

If this is the case, the configuration could be enhanced in a variety of ways, either by using a ternary operator or the parser function getMatchingValue() in the expression or simply by creating several post functions with different conditional executions.

This is an example of a valid ternary operator, where 5 days would be added to the current date if the priority is high and 15 if it is set to any other value:

%{%{issue.priority} = "High" ? dateTimeToString( {system.currentDateTime} + 5*DAY , "YYYY-MM-DD", RUN_AS_LOCAL, RUN_AS_LANG) : dateTimeToString( {system.currentDateTime} + 15*DAY , "YYYY-MM-DD", RUN_AS_LOCAL, RUN_AS_LANG)}

I am part of the support for JWT for Jira Cloud. Please, do not hesitate to contact us via our Support Service Desk if you have any question.

Best regards,

Vicente

@Alex Koxaras _Relational_ 

Thanks for your time and reply, unfortunately being relatively new to  admin side of Jira and still learning.

The Team Managed Project I have manually cloned from a live project has the following SLA's - I think the Time to Done is the type of SLA I need to focus on. Time to done.pngTime to first repsponse.png

I think I need to firstly somehow get the Due date field populated with a date for each of the given Time Goals 18h, 45h, 90h or 135h

 

 Due Date Field.png

Once I can get a static Due date populated, I think I could then work on the Due date getting refreshed depending on the status of the ticket.

Currently when I run a report for our customer the Due date is empty, the customer has asked about the Due date - I could manually populate the date but that doesn't work for me. 

I've downloaded the Time to SLA attempted to configure it - unfortunately a lot of the configurations and drop down possibilities went over my head, having said that Time to SLA now displays this on the ticket. 

 

Time to SLA example.png
 Ideally as mentioned above the Due Date field would be populated so it is displayed in the export report we use.

Automation would be the preferred way to populate the Due date,. Only because I've not yet looked at the work flow module a and am a bit stand off - ish of that module.


As you mentioned Once that is achieved, I could look at how to keep the due date updated dependent on the SLA Time Goal for that Project.


Prior to raising this post,  I attempted to Automate the Due Date with the following from Comments expecting the Due date to be populated. it never happened.

Automation_0.pngAutomation_1.png


the issue.customfield_10048 was found by by entering the ticket number in the <issuekey> searching on the SLA name and then pasting the customfield number. finding custom field.png

Which hasn't appeared to have  worked.

 

@Vicente Domínguez _Decadis AG_  unfortunately I'll have to wait for a work colleague to return to work to ask for their assistance in understanding your post.

I've since found an Automation in another project that a previous manager set up but never documented how it was achieved. The Audit logs only show it has worked triggered twice. in 3 years


With that Project open to Automation on one screen and my Ttest Project open on another screen in an attempt to reproduce the configurations one by one I'm unable to populat a field.

The Issue Transitioned appears easy to follow 

1 Automation Due date issue transitioned .png

When I get to the issue fields condition  the working automation displays  customfield_10154 (Priority -G..... 

This isn't an option from the drop down, I can't select the text copy and paste that text into my test project and amend., I'm unable to see the full text 

I also noticed that the drop down only shows 50 of 134 - is it possible to display the remaining options 

 

2 Automation Due date issue fields condition.png

 Cheers in advance

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS

Atlassian Community Events