Jira Automation: Track Previous Worklog Time

[Paka]

Hi everyone,

I’m trying to create a Jira Automation Rule that adjusts vacation days based on worklog updates, but I need a way to track the previously logged value to ensure correct vacation day calculations.

Requirements:

 If a user logs 4+ hours on a "Vacation" task, decrease vacation days by 1.

 If a user updates the worklog from 4+ hours to less than 4 hours, increase vacation days by 1 (undoing the previous decrease).

 If the worklog remains under 4 hours and is updated multiple times (e.g., 3 → 2 → 1 hours), it should be ignored (no additional vacation days should be added back).

 If a user logs 4+ hours and then updates it to 5, 6, 7, or more hours, it should NOT decrease vacation days again (only the first log of 4+ hours should trigger a decrease).

Question:

How can I reliably track the previous worklog time so that I can ensure the correct vacation day adjustments?

[Bill Sheboy · Accepted solution]

Hi @Paka -- Welcome to the Atlassian Community!

For a question like this, context is important for the community to help.  Please post the following:

* what type of project is this (e.g., company-managed, team-managed, etc.), 
* an image of your complete automation rule in a single image,
* images of any relevant actions / conditions / branches,
* an image of the audit log details showing the rule execution, and
* explain what is not working as expected and why you believe that to be the case.

Kind regards,
Bill

[Vishal Biyani]

@Paka 

Required few clarifications to understand your use case better 

• Is it ensured that only 1 user logs time against a unique Vacation issuetype?
• if user X has to take 2 days timeoff, will they enter 16 hours total (Day 1 = 8 hours and Day 2 = 8 hours) or will user X create 2 Vacation tasks and enter 8 hours against each?
• Where is Vacation days stored? is it on Vacation issuetype and what is the default value of Vacation days? if it goes negative, then what needs to be done?

NOTE: Work log time is rolled under Time Tracking (Time Spent/Time remaining). So instead of relying on individaul worklog entries, have you thought about checking the value of Time Tracking field (<=4 and >4 <=8)?

[Paka]

@Vishal Biyani 

1.Yes every user has its on vacation task

2. if user takes 2 days of he should log etleast 4> hours on  two days 

so if you want 2 days you log 4+ hours for each day you want in separate logs

3.I have two custom fields Vacation days that will be manually updated for each employee based of their vacation days and i have vacation days remaining that should increase or decrease based of automation logic i put in my question.